If you’re using VBA to streamline your Windows programs and operations, making use of the shortcut keys in the following list can help you streamline even more quickly and easily.
| Press | To Do This | Press | To Do This |
|---|---|---|---|
| Alt+F11 | Open the VBA editor | F1 | Get help on any selected item |
| Alt+F8 | Display a list of macros | F2 | Display the Object Browser window |
| Ctrl+Break | Perform an emergency stop of the program | F4 | Display the Properties window |
| Ctrl+G | Display the Immediate window | F5 | Start the program |
| Ctrl+I | List the quick information for the selected element | F7 | Display the Code window after selecting a form or control |
| Ctrl+J | List the properties and methods for an object | F9 | Add a breakpoint |
| Ctrl+R | Display Project Explorer | Shift+F7 | Display the form that corresponds to the active Code window |
| Ctrl+Shift+I | List the parameter information for the selected element | Shift+F9 | Add a quick watch for the highlighted text |
| Ctrl+Shift+J | List the constants associated with an enumeration | Ctrl+Tab | Move to the next Code or UserForm window |
dummies
Source:http://www.dummies.com/how-to/content/vba-keyboard-shortcuts.html
No comments:
Post a Comment