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.