The complete list of Excel VBA Editor (VBE) keyboard shortcuts are for U.S. keyboard layout and Windows Operation system.
| # | Action | Shortcut |
|---|---|---|
| 1 | Help | F1 |
| 2 | Object Browser | F2 |
| 3 | Find | F3 |
| 4 | Properies Window | F4 |
| 5 | Run | F5 |
| 6 | Switch Split Windows | F6 |
| 7 | Goto Window Of Object | F7 |
| 8 | Step | F8 |
| 9 | Breakpoint | F9 |
| 10 | Activate Menu Bar | F10 |
| 11 | Toggle Insert Mode | Insert |
| 12 | Delete | Delete |
| 13 | Beginning Of Line | Home |
| 14 | End Of Line | End |
| 15 | Page Up | PgUp |
| 16 | Page Down | PgDn |
| 17 | Left | ← |
| 18 | Right | → |
| 19 | Up | ↑ |
| 20 | Down | ↓ |
| 21 | Indent | Tab |
| 22 | New Line | Enter |
| 23 | Delete Prev Char | BackSpace |
| 24 | Procedure Definition | Shift F2 |
| 25 | Find Prev | Shift F3 |
| 26 | Find Next | Shift F4 |
| 27 | Procedure Step | Shift F8 |
| 28 | Quick Watch | Shift F9 |
| 29 | Show Right Click Menu | Shift F10 |
| 30 | Paste | Shift Insert |
| 31 | Select To Start Of Line | Shift Home |
| 32 | Select To End Of Line | Shift End |
| 33 | Select To Top Of Module | Shift PgUp |
| 34 | Select To End Of Module | Shift PgDn |
| 35 | Extend Selection Left 1 Char | Shift ← |
| 36 | Extend Selection Right 1 Char | Shift → |
| 37 | Extend Selection Up | Shift ↑ |
| 38 | Extend Selection Down | Shift ↓ |
| 39 | Un-indent | Shift Tab |
| 40 | Focus To Object Box | Ctrl F2 |
| 41 | Close Window | Ctrl F4 |
| 42 | Run To Cursor | Ctrl F8 |
| 43 | Activate Menu Bar | Ctrl F10 |
| 44 | Select All Text | Ctrl B |
| 45 | Copy | Ctrl C |
| 46 | Export Module | Ctrl E |
| 47 | Find | Ctrl F |
| 48 | Immediate Window | Ctrl G |
| 49 | Replace | Ctrl H |
| 50 | Turn On Quick Info | Ctrl I |
| 51 | List Members | Ctrl J |
| 52 | Show Call Stack | Ctrl L |
| 53 | Import File | Ctrl M |
| 54 | New Line | Ctrl N |
| 55 | Ctrl P | |
| 56 | Project Window | Ctrl R |
| 57 | Save | Ctrl S |
| 58 | Show Available Components | Ctrl T |
| 59 | Paste | Ctrl V |
| 60 | Cut | Ctrl X |
| 61 | Cut Entire Line | Ctrl Y |
| 62 | Undo | Ctrl Z |
| 63 | Copy | Ctrl Insert |
| 64 | Delete To End Of Word | Ctrl Delete |
| 65 | Top Of Module | Ctrl Home |
| 66 | End Of Module | Ctrl End |
| 67 | Top Of Current Procedure | Ctrl Page Up |
| 68 | End Of Current Procedure | Ctrl Page Down |
| 69 | Left Word | Ctrl Left Arrow |
| 70 | Right Word | Ctrl Right Arrow |
| 71 | Previous Procedure | Ctrl Up Arrow |
| 72 | Next Procedure | Ctrl Down Arrow |
| 73 | Turn On Complete Word | Ctrl Space Bar |
| 74 | Cycle Windows | Ctrl Tab |
| 75 | Delete To Start Of Word | Ctrl BackSpace |
| 76 | Close VBE | Alt F4 |
| 77 | Run Error Handler | Alt F5 |
| 78 | Switch Between Last 2 Windows | Alt F6 |
| 79 | Step Error Handler | Alt F7 |
| 80 | Return To Application | Alt F11 |
| 81 | Add-Ins Menu | Alt A |
| 82 | Debug Menu | Alt D |
| 83 | Edit Menu | Alt E |
| 84 | File Menu | Alt F |
| 85 | Help Menu | Alt H |
| 86 | Insert Menu | Alt J |
| 87 | Format Menu | Alt O |
| 88 | Close & Return | Alt Q |
| 89 | Run Menu | Alt R |
| 90 | Tools Menu | Alt T |
| 91 | View Menu | Alt V |
| 92 | Window Menu | Alt W |
| 93 | System Menu | Alt Space Bar |
| 94 | Cycle Applications | Alt Tab |
| 95 | Undo | Alt BackSpace |
| 96 | Previous Position | Ctrl Shift F2 |
| 97 | Clear All Breakpoints | Ctrl Shift F9 |
| 98 | Turn On Param Info | Ctrl Shift I |
| 99 | Turn On List Properties | Ctrl Shift J |
No comments:
Post a Comment