When you are using VBA in Excel you might be like to move around only using keyboard.
Following are the shortcut available:
- F7: It Switches to the Code Window for the selected object (node) in the project explorer.
- F4: It Switches to the Property window and display the properties for the selected object.
- Ctrl + R: It Switches to the Project Explorer.
- Alt + F11: It will allow you to toggle between Visual Basic Editor and Excel Sheet.
- Shift + F12: It allows you to display definition of a selected function or subroutine in the code window.
Related posts:
