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

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

Thanks,

Brad.)

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.)