Determine name of combo box

[Gig]

I have a combo box set up on a worksheet from the forms toolbar. I
need to write a macro for it, but first need the name of the combo
box. I've not been able to locate it in the visual basic editor. Can
anyone tell me how I can find the name of it, so I can incorporate it
in my macro?

Thanks,
Greg

 

[Bob Phillips]

Select it, and look in the Names box to the left of the formula bar.

--
---
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

 

[merjet]

Right-click it. The name will appear in the Name Box, e.g. "Drop Down
1".

Hth,
Merjet

 

[Dave Peterson]

Click on it in excel.
Look at the Namebox (to the left of the formula bar)

You should see something like:
Drop Down 1
or
Drop Down 2
or...

I'm not sure what you're doing, but if you're running a macro that's called by
changing that dropdown, you don't need the name. Maybe you can do something
like:

Dim myDD as DropDown
set myDD = activesheet.dropdowns(application.caller)

Then you can do things based on that object.

msgbox mydd.name 'if you really want the name
or
msgbox mydd.topleftcell.address