html>
VBA Shortcut Keys
Pearson Software Consulting Services
   
VBA Editor Shortcut Keys  
  
    |  |  |  | 
  
    |  |  |  | 
  
    |  | NOTE: The key assignments listed here are for standard US-English keyboards. Key 
mappings on non-US-English keyboards are slightly different. |  | 
  
    |  | 
| Key | Alone | Shift | Ctrl | Alt | Shift Ctrl |  
| F1 | Help |  |  |  |  |  
| F2 | Object Browser | Procedure Definition | Focus To Object Box |  | Previous Position |  
| F3 | Copy | Find Prev |  |  |  |  
| F4 | Properies Window | Find Next | Close Window | Close VBE |  |  
| F5 | Run |  |  | Run Error Handler |  |  
| F6 | Switch Split Windows |  |  | Switch Between Last 2 Windows |  |  
| F7 | Goto Window Of Object |  |  | Step Error Handler |  |  
| F8 | Step | Procedure Step | Run To Cursor |  |  |  
| F9 | Breakpoint | Quick Watch |  |  | Clear All Breakpoints |  
| F10 | Activate Menu Bar | Show Right Click Menu | Activate Menu Bar |  |  |  
| F11 |  |  |  | Return To Application |  |  
| F12 |  |  |  |  |  |  
| Key | Alone | Shift | Ctrl | Alt | Shift Ctrl |  
| A | Normal Characters |  |  Select All | Add-Ins Menu |  |  
| B |  |  |  |  |  |  
| C |  |  | Copy |  |  |  
| D |  |  |  | Debug Menu |  |  
| E |  |  | Export Module | Edit Menu |  |  
| F |  |  | Find | File Menu |  |  
| G |  |  | Immediate Window |  |  |  
| H |  |  | Replace | Help Menu |  |  
| I |  |  | Turn On Quick Info |  | Turn On Param Info |  
| J |  |  | List Members | Insert Menu | Turn On List Properties |  
| K |  |  |  |  |  |  
| L |  |  | Show Call Stack |  |  |  
| M |  |  | Import File |  |  |  
| N |  |  | New Line |  |  |  
| O |  |  |  | Format Menu |  |  
| P |  |  | Print |  |  |  
| Q |  |  |  | Close & Return |  |  
| R |  |  | Project Window | Run Menu |  |  
| S |  |  | Save |  |  |  
| T |  |  | Show Available
Components | Tools Menu |  |  
| U |  |  |  |  |  |  
| V |  |  | Paste | View Menu |  |  
| W |  |  |  | Window Menu |  |  
| X |  |  | Cut |  |  |  
| Y |  |  | Cut Entire Line |  |  |  
| Z |  |  | Undo |  |  |  
| ` (~) |  |  |  |  |  |  
| Key | Alone | Shift | Ctrl | Alt | Shift Ctrl |  
| 1 (!) |  |  |  |  |  |  
| 2 (@) |  |  |  |  |  |  
| 3 (#) |  |  |  |  |  |  
| 4 ($) |  |  |  |  |  |  
| 5 (%) |  |  |  |  |  |  
| 6 (^) |  |  |  |  |  |  
| 7 (&) |  |  |  |  |  |  
| 8 (*) |  |  |  |  |  |  
| 9 (() |  |  |  |  |  |  
| 0 ()) |  |  |  |  |  |  
| - |  |  |  |  |  |  
| = (+) |  |  |  |  |  |  
| [ |  |  |  |  |  |  
| ] |  |  |  |  |  |  
| ; (semicolon) |  |  |  |  |  |  
| ' (apostrophe) |  |  |  |  |  |  
| : (colon) |  |  |  |  |  |  
| / |  |  |  |  |  |  
| \ |  |  |  |  |  |  
| Key | Alone | Shift | Ctrl | Alt | Shift Ctrl |  
| Insert | Toggle Insert Mode | Paste | Copy |  |  |  
| Delete | Delete |  | Delete To End Of Word |  |  |  
| Home | Beginning Of Line | Select To Start Of Line | Top Of Module |  |  |  
| End | End Of Line | Select To End Of Line | End Of Module |  |  |  
| Page Up | Page Up | Select To Top Of Module | Top Of Current
Procedure |  |  |  
| Page Down | Page Down | Select To End Of Module | End Of Current Procedure |  |  |  
| Left Arrow | Left | Extend Selection Left 1 Char | Left Word |  |  |  
| Right Arrow | Right | Extend Selection Right 1 Char | Right Word |  |  |  
| Up Arrow | Up | Extend Selection Up | Previous Procedure |  |  |  
| Down Arrow | Down | Extend Selection Down | Next Procedure |  |  |  
| Space Bar |  |  | Turn On Complete Word | System Menu |  |  
| Tab | Indent | Un-indent | Cycle Windows | Cycle Applications |  |  
| Enter | New Line |  |  |  |  |  
| BackSpace | Delete Prev Char |  | Delete To Start Of Word | Undo |  |  | 
          | 
  
    |  | 
          | 
  
    |  | You can download this as an Excel workbook
	here. |  | 
  
    |  |  |  | 
 
Created By Chip Pearson and 
Pearson Software Consulting, LLC 
This Page:  
             
Updated: November 06, 2013     
MAIN PAGE   
About This Site   
Consulting   
Downloads   
Page Index    
Search   
Topic Index   
What's New   
Links  
Legalese And Disclaimers
chip@cpearson.com
© Copyright 1997-2007  Charles H. Pearson