shortcut keys
The UK's Number 1 for Microsoft Office Training Add this page to your favourites/bookmarksBookmark page
 
View printable version of pagePrintable version
Plus One Google
Customer: Sign in
Delegate: Sign in
Trainer: Log in

Forum home » Delegate support and help forum » Microsoft Excel VBA Training and help » Shortcut Keys

Shortcut Keys

resolvedResolved · Low Priority · Version 2007

replyReply Wed 19 Jan 2011, 10:10Delegate Ben said...

Ben has attended:
Excel VBA Intro Intermediate course
Excel VBA Advanced course

Shortcut Keys

How do you code a shortcut key into the VBA text? Is it even possible without going through the front end to define through the Macro Options Toolbox?

Thanks

For upcoming training course dates see: Pricing & availability

replyReply Wed 19 Jan 2011, 10:33Trainer Anthony said...

RE: Shortcut Keys

Hi Ben, there's a useful walkthrough of this here:

http://vbadud.blogspot.com/2007/06/assigning-shortcut-keys-excel-macros.html

Hope this helps,

Anthony

Tue 25 Jan 2011: Automatically marked as resolved.

 

Please browse our web site to find out more about
excel consulting and other Microsoft training courses.

Excel tip:

Paste functions box quickly

If you want to do a formula using the paste functions box press SHIFT + F3.

View all Excel hints and tips


Microsoft Certified Partner Accredited Training Provider: Institute of IT Training Institute of Leadership and Management - Certified Courses Security Seal verified by visa, mastercard securecard