Thread: combo box
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Phillip[_5_] Phillip[_5_] is offline
external usenet poster
 
Posts: 33
Default combo box

On 23 Apr, 19:01, Carmel wrote:
How do you refereNce a combobox created in excel using the hfoms toolbar.
Excel gives it a name Drop down 3 and I *need to filter some data based on
the item selected from the combo

THANKS


Try this

Dim dr As DropDown
Set dr = ActiveSheet.DropDowns.Item("Drop Down 1")
MsgBox Range(dr.LinkedCell).Value