combo box
 

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

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