[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
-----Original Message-----
I need to reset the previous selections on some pull
down menus ... What is
the best way?

Thanks,

Brad.)