View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Brian Stigler Brian Stigler is offline
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