Using a macro to reset a dropdown box value in Excel/VB?

Question

I have numerous dropdown boxes in an Excel form that, when I "reset" the form using a macro, I want to also reset the dropdown value to the first value in the list. Can you help me with scripting this?

Answer 1

No, No, No
Just do this

ListBox1.Listindex = 0

Thats it

Enjoy my profile, I am the VBAXLMan

Answer 2

Excel Drop Down List Macro

Answer 3

Okay
You don't need to write the coding. Simply follow these instructions.

↓ Open Excel
↓ Go to View - Toolbars - Forms
↓ In the small tool bar pop up select "button"
↓ Drag out a button
↓ Call the button "..."

↓ Go to Tools
↓ Macro
↓ Record new macro
↓ Give it a name
↓ Click record new macro
↓ Now act out the action you want, all of your moves are recorded.

Simply delete / clear all the cells data you do not want (or highlight the cells to clear, right hand click and select clear cells), and click the drop down menus back to the position you want.

When you are finished click the stop recording button.
Now right hand click the button you made earlier and click assign macro.

Now when you click the button the actions you recorded will be dupliacted by a macro that is automatically made by Excel in Visual Basic.

Answer 4

ok you do not favor to jot down the coding. only persist with those training. ? Open Excel ? flow to View - Toolbars - kinds ? contained in the small device bar pop up pick "button" ? Drag out a button ? call the button "..." ? flow to equipment ? Macro ? record new macro ? supply it a acceptance ? click record new macro ? Now act out the action you want, all of your strikes are recorded. only delete / clean each and each of the cells information you do not desire (or spotlight the cells to bathe, suitable hand click and choose clean cells), and click the drop down menus again to the placement you want. once you're complete click the stop recording button. Now suitable hand click the button you made before and click assign macro. Now once you click the button the moves you recorded will be dupliacted by technique of a macro it truly is immediately made by technique of Excel in seen consumer-friendly.

Answer 5

Private Sub myResetButton_Click()
myComboBox.Text = myComboBox.List(0)
End Sub