How to determine which button was clicked on the modified right-click menu

P

Patrick Choi

I have modified the right-click menu to contain new control items. I wish to
know which button on the newly modified menu was clicked by the user so that
I can appoint differnet macros for different button clicks.

May anyone please give me a clue? Thanks a lot!
 
C

Chip Pearson

Patrick,

You can use the ActionControl property to get a reference to the control
that was clicked. E.g.,

Msgbox Application.CommandBars.ActionControl.Caption
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

right click menu 2
Custom right-click menu without changing Excel.App 1
How Do I? Determine Which Button was Right-Clicked, Pass to ContextMenu 1
right click menu 3
Which button was clicked 1
Screen position of commandbar button in Excel 2007 ? 11
Undo button in the context menu (right click menu) 7
How Can I Tell Which Button Was Right-Clicked? 4

Top