Navigation in the VBA Window

An Excel shortcut

I recently found a useful keyboard shortcut for the VBA code window. I tried an Excel shortcut that helped in the VBA window.

To open the VBA window use Alt + F11 or you can right click a sheet tab and choose View Code.

In a code module you can use Ctrl + PageDown and Ctrl + PageUp to move between Subs/Functions in the current module.

This is a quick technique if you have long pieces of code.

In Excel these shortcuts allow you to move between sheets.


Please note: I reserve the right to delete comments that are offensive or off-topic.

Leave a Reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.