Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Determine name of combo box
Right-click it. The name will appear in the Name Box, e.g. "Drop Down
1". Hth, Merjet |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Use Combo Box value to determine macro used | Excel Worksheet Functions | |||
20 different numbers want excel to determine which combo add to x | Excel Discussion (Misc queries) | |||
Excel VBA Combo Box Populating dependent on other combo box choices | Excel Programming | |||
Filtered list for Combo Box ListFillRange - Nested Combo Boxes | Excel Programming | |||
"Combo Box - getting control combo box to stick in place in worksh | Excel Discussion (Misc queries) |