How to: reset the pull down menus to item 1 on start up?
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
-----Original Message-----
I need to reset the previous selections on some pull
down menus ... What is
the best way?
Thanks,
Brad.)
|