Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 2
Default Getting the Label or Caption of MenuItem Selected

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   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 11,272
Default Getting the Label or Caption of MenuItem Selected

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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
label caption gramps Excel Discussion (Misc queries) 0 November 1st 07 03:56 PM
Is it a comment ? or a label ? or a caption ?.... mars Excel Discussion (Misc queries) 2 May 24th 07 11:15 PM
Linking Cell to Label Caption papaitaliano Excel Worksheet Functions 1 March 21st 06 05:23 PM
changing the caption of a label Koos Excel Programming 4 October 18th 03 02:36 PM
label caption Rod Taylor Excel Programming 2 July 31st 03 03:25 AM


All times are GMT +1. The time now is 11:29 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"