Common Shortcut Keys in VBA 2007 Editor

Writing, editing, and testing your VBA code in Visual Basic editor will run more smoothly if you learn these helpful shortcut keys and their functions:



























































ActionShortcut Key
Get helpF1
View Object BrowserF2
View propertiesF4
View Code windowF7
Open Project ExplorerCtrl+R
Close and return to AccessAlt+Q
Switch to AccessAlt+F11
View Immediate windowCtrl+G
View shortcut menuShift+F10 (or right-click)
View definitionShift+F2
Go to last positionCtrl+Shift+F2
Run a Sub/UserFormF5
Stop code executionCtrl+Break








dummies

Source:http://www.dummies.com/how-to/content/common-shortcut-keys-in-vba-2007-editor.html

No comments:

Post a Comment