combo box

  • Thread starter Thread starter Carmel
  • Start date Start date
C

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
 
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
Click to expand...

Try this

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