ExcelBanter - getting values from drop down

ExcelBanter (https://www.excelbanter.com/)

- Excel Programming (https://www.excelbanter.com/excel-programming/)

- - getting values from drop down (https://www.excelbanter.com/excel-programming/374626-getting-values-drop-down.html)

violet

getting values from drop down

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.

Tom Ogilvy

getting values from drop down

Dim dp as DropDown
set dp = ActiveSheet.Dropdowns("Drop Down 3")
msgbox dp.List(dp.Listindex)

--
Regards,
Tom Ogilvy

"violet" wrote in message
...
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.

All times are GMT +1. The time now is 12:13 AM.