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.