How to name a Combo Box

[Guest]

How do you name a combo box that has been created in a worksheet? I've been able to assign a range to the box, but I don't know how to assign a name to the object so that I can reference it in VBA.

Thanks,
Will

 

[Guest]

Will,

If it's a forms control (which I think it is), then I don't think you can name it. You will have to use a visual basic control instead. Click view | toolbars | visual basic, then from the vb toolbar, select the combo box control (click the tools icon if it's not visible) and insert that instead of the the forms control. To rename the control, right click on the object and select properties. Change the name on the first line to whatever name you want for your combobox.

Aloha!

 

[]-[ /-\ \/\/ /-\ | | /-\]

(above post from me)

 

[wcassell]

Thanks,
That did the trick.

Will