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.