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

  • Thread starter Thread starter Brad Patterson
  • Start date Start date
B

Brad Patterson

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

Thanks,

Brad.)
 
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
 
Back
Top