To get your tasks done quickly in the Immediate window (which lets you run code anytime, right on the spot) and Code window (used for writing, editing, and viewing VBA) use these VBA shortcuts:
| Action | Shortcut Key |
|---|---|
| Move cursor right one character | -→ |
| Select character to right | Shift+-→ |
| Move cursor right one word | Ctrl+-→ |
| Select to end of word | Ctrl+Shift+-→ |
| Move cursor left one character | <--- |
| Select character to left of cursor | Shift+<--- |
| Move cursor left one word | Ctrl+<--- |
| Move cursor to start of line | Home |
| Select text to start of line | Shift+Home |
| Move cursor to end of line | End |
| Select text to end of line | Shift+End |
| Move cursor up a line | ↑ |
| Move cursor down a line | ↓ |
| Move cursor to next procedure | Ctrl+↓ |
| Move cursor to previous procedure | Ctrl+↑ |
| Scroll up one screen | PgUp |
| Scroll down one screen | PgDn |
| Go to top of module | Ctrl+Home |
| Select all text to top of module | Ctrl+Shift+Home |
| Go to bottom of module | Ctrl+End |
| Select all text to bottom of module | Ctrl+Shift+End |
| Cut selection | Ctrl+X |
| Copy selection | Ctrl+C |
| Paste selection | Ctrl+V |
| Cut current line to Clipboard | Ctrl+Y |
| Delete to end of word | Ctrl+Delete |
| Delete character or selected text | Delete (Del) |
| Delete character to left of cursor | Backspace |
| Delete to beginning of word | Ctrl+Backspace |
| Undo | Ctrl+Z |
| Indent line | Tab |
| Outdent line | Shift+Tab |
| Find | Ctrl+F |
| Replace | Ctrl+H |
| Find Next | F3 |
| Find Previous | Shift+F3 |
| Get help with selected word | F1 |
| Get Quick Info | Ctrl+I |
dummies
Source:http://www.dummies.com/how-to/content/vba-2007-shortcuts-for-immediate-and-code-windows.html
No comments:
Post a Comment