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!! :)
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
