VBA Keyboard Shortcuts

PressTo Do ThisPressTo Do This
Alt+F11Open the VBA editorF1Get help on any selected item
Alt+F8Display a list of macrosF2Display the Object Browser window
Ctrl+BreakPerform an emergency stop of the programF4Display the Properties window
Ctrl+GDisplay the Immediate windowF5Start the program
Ctrl+IList the quick information for the selected elementF7Display the Code window after selecting a form or control
Ctrl+JList the properties and methods for an objectF9Add a breakpoint
Ctrl+RDisplay Project ExplorerShift+F7Display the form that corresponds to the active Code window
Ctrl+Shift+IList the parameter information for the selected elementShift+F9Add a quick watch for the highlighted text
Ctrl+Shift+JList the constants associated with an enumerationCtrl+TabMove to the next Code or UserForm window

Comments

Popular posts from this blog

50 Excel VBA Oral Interview Questions