View Single Post
 
Old 11-19-2018, 06:55 PM
trevorc trevorc is offline Windows 7 32bit Office 2013
Competent Performer
 
Join Date: Jan 2017
Posts: 173
trevorc will become famous soon enoughtrevorc will become famous soon enough
Default 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.
Reply With Quote