Software Development

Use a shortcut to cycle through Visual Basic modules

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.


Most of the time, you don't need to hit the [Windows} key. Ctrl-Tab will do the job. Note that Ctrl-Shift-Tab will cycle in the reverse direction. Some applications use Ctrl-F6 as the key combo to cycle through open windows in an application. Word is a case in point. You'll usually find that at least one of these options works. Sometimes both do. Regards

Editor's Picks