#1
|
|||
|
|||
Capture menu selections in VBA
Hi Again, Is it possible to capture/See if a user has selected a command from the excel menu bar and then act on the selection using VBA. This is in relation to my question about using VBA for creating comments. When I tried to record the creation of a comment the VBA code is just creating the comment, I need to capture when the comment is being created and take over using VBA to pre-fill the comment with some text and then hand back control to the user for more text input. |
Thread Tools | |
Display Modes | |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Complicated Macro - Capture from Excel | sahrens1 | Word VBA | 2 | 06-25-2017 09:47 AM |
Need to capture SQL Connected data at intervals | Stacyg | Excel Programming | 1 | 07-22-2015 12:07 AM |
Capture a Font in a Variable | joatmon | Excel Programming | 1 | 05-30-2012 08:23 PM |
Adding Macro menu to the right click menu (Word 2007) | masam123 | Word | 0 | 10-14-2011 04:05 AM |
How to capture start and ending Ref. Nos. in an array | KIM SOLIS | Excel | 5 | 09-07-2011 07:43 AM |