getting values from drop down

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

i have a drop down list call "drop down 3". how can i make use of the value
selected by the user in my macro? i need to identify the value that is
selected.
 
Dim dp as DropDown
set dp = ActiveSheet.Dropdowns("Drop Down 3")
msgbox dp.List(dp.Listindex)
 
Back
Top