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
|