Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 11-19-2018, 06:55 PM
trevorc trevorc is offline Capture menu selections in VBA Windows 7 32bit Capture menu selections in VBA Office 2013
Competent Performer
Capture menu selections in VBA
 
Join Date: Jan 2017
Posts: 174
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
Reply

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
Capture menu selections in VBA Need to capture SQL Connected data at intervals Stacyg Excel Programming 1 07-22-2015 12:07 AM
Capture menu selections in VBA 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

Other Forums: Access Forums

All times are GMT -7. The time now is 03:49 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft