When working in the Visual Basic Editor with the Explorer open, each open module is just a click away. But if the Explorer is closed, you can use this handy keyboard shortcut to cycle through all open modules.
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.