combo box

[Carmel]

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

 

[Phillip]

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 basedon
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