Determine name of combo box
 

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

Determine name of combo box
 

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)



"Gig" wrote in message
oups.com...
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

Determine name of combo box
 

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

Hth,
Merjet

Determine name of combo box
 

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

Gig wrote:

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

--

Dave Peterson