Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I've created a custom menu on the command bar with a handfull of menu items
and some sub-menu items. I have assigned an on-action event to each of these but would like to be able to get the caption property for the menu item or sub-menu item selected. Is there a way to get this information other than by the fact that the event goes to the assigned on-action routine? Thanks, B |
#2
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Brian,
As soon as a commandbar is selected/clicked the OnAction macro is invoked. So why would you not get the caption at that point. You can get the caption with Application.CommandBars.ActionControl.Caption -- HTH Bob Phillips ... looking out across Poole Harbour to the Purbecks (remove nothere from the email address if mailing direct) "Brian Stigler" wrote in message ... I've created a custom menu on the command bar with a handfull of menu items and some sub-menu items. I have assigned an on-action event to each of these but would like to be able to get the caption property for the menu item or sub-menu item selected. Is there a way to get this information other than by the fact that the event goes to the assigned on-action routine? Thanks, B |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
label caption | Excel Discussion (Misc queries) | |||
Is it a comment ? or a label ? or a caption ?.... | Excel Discussion (Misc queries) | |||
Linking Cell to Label Caption | Excel Worksheet Functions | |||
changing the caption of a label | Excel Programming | |||
label caption | Excel Programming |