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.