| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to determine which button was clicked on the modified right-click menu
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! |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
How to determine which button was clicked on the modified right-click menu
Patrick,
You can use the ActionControl property to get a reference to the control that was clicked. E.g., Msgbox Application.CommandBars.ActionControl.Caption -- Cordially, Chip Pearson Microsoft MVP - Excel www.cpearson.com "Patrick Choi" wrote in message ... 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! |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Macro to determine row of page break on modified presentation sheet? | Excel Discussion (Misc queries) | |||
| Shortcut menu won't appear when I click right mouse button. | Excel Discussion (Misc queries) | |||
| let a sub recognise the name of the button that has been clicked. | Excel Discussion (Misc queries) | |||
| Determine when checkbox is clicked | Excel Discussion (Misc queries) | |||
| Options (under the tools menu) won't open when clicked in Excel | Excel Discussion (Misc queries) | |||
Linear Mode
