98.7% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View Reviews
Forum home » Delegate support and help forum » Microsoft Excel VBA Training and help » Keyboard Shortcuts
Keyboard Shortcuts
Resolved · Low Priority · Version 2007
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!! :)
Mon 23 May 2011, 13:12Trainer Anthony said...
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.
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. |
Excel tip:Display pictures on Chart Data PointReplacing a single chart data point bar with a picture. |
