Most users know that pressing [Alt]+[Tab] cycles through all the open windows. Using this shortcut, you can quickly access a specific file. When you're work with Visual Basic for Applications code in the Visual Basic Editor, you can use a similar keyboard combination to cycle through all the open modules: Simply press [Ctrl]+[Windows]+[Tab] to access open modules (in order as they were opened).
You must be in the Visual Basic Editor for this shortcut to work. Other environments respond differently to the shortcut. For instance, pressing [Ctrl]+[Windows]+[Tab] in Access cycles through the different object lists in the Database window.
Susan Sales Harkins is an IT consultant, specializing in desktop solutions. Previously, she was editor in chief for The Cobb Group, the world's largest publisher of technical journals.