Forum home » Delegate support and help forum » Microsoft Excel VBA Training and help » Keyboard Shortcuts
|
|
|
The UK's most regular Training information: |
|
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
Keyboard Shortcuts
Resolved · Low Priority · Version 2007
Reply Wed 18 May 2011, 15:48Delegate Gari said...
Gari has attended:
Excel VBA Intro Intermediate course
Keyboard Shortcuts
A lot of the procedures that I am looking to convert don't tend to make use of buttons or visual prompts; I tend to just hit CTRL + <letter> once I've finished populating the excel with data and it runs - usually emailing the excel as an attachment to someone.
This has previously been set up via Macro recorder, however I am keen to know if this is something that I can code into my Proceedure (and if so, which section would be the best section to define this?)
Many thanks!! :)
For upcoming training course dates see: Pricing & availability
RE: Keyboard Shortcuts
Hi Gari, thanks for your query. You can indeed hard code keyboard shortcuts to trigger subroutines. Here's a useful walkthrough:
http://vbadud.blogspot.com/2007/06/assigning-shortcut-keys-excel-macros.html
Hope this helps,
Anthony
Mon 30 May 2011: Automatically marked as resolved.
|