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

Hyperlink fails to open on the first click 0
Rows right click menu? 2
right click menu 2
Synchronization problems while moving folders to new email 1
Custom right-click menu without changing Excel.App 1
Which picture was clicked 2
Return a string based on which Textbox is clicked 2
Get line no from right click menu ("Cell") 5

Top