How to: reset the pull down menus to item 1 on start up?

[Brad Patterson]

I need to reset the previous selections on some pull down menus ... What is
the best way?

Thanks,

Brad.)

 

[Patrick Molloy]

what do you mean by dropdown? a data validation cell, a
combobox on the sheet, a combobox on a userform?
With a combobox, set the ListIndex to -1 ( for no
selection) or to zero to set the first item


Sub ResetCombo()

With Sheet1.ComboBox1
.ListIndex = -1
.Value = "select..."
End With

End Sub


Patrick Molloy
Microsoft Excel MVP