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)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Data Validation List (conditional) 2
How to dynamically change the list in drop down list based on thevalue of another cell? 1
Set Column choice to a variable from a Drop Down 4
Drop down list - link to another worksheet 4
active combobox - possible to configure as display value andcoordinate value? 3
Write to intersect of a row and column 7
EXCEL DROP DOWN 2
Drop Down with hidden values 1

Back
Top