How do I Toggle From UserForm Back to a Document in Word?

Use Windows shortcut keys to toggle between Excel and Word.

When using information contained with a Microsoft Word document as data for your Excel UserForm, it can be tedious to keep changing from the UserForm to the Word Document. This is especially true if you have additional windows open on your computer. In cases like this, you can use Windows shortcut keys to toggle back and forth between UserForm and Word. By toggling, you won't have to waste time searching for the right screen on your Windows Task Bar.

Instructions

1. Ensure that the UserForm document and the Word document are open on your computer.

2. Press the "Alt" key on your keyboard. While holding down the "Alt" key, simultaneously press and release the "Tab" key.

3. Keep pressing and releasing the "Tab" key until the item you want to bring to the forefront is highlighted. In this example, you can stop when the UserForm is highlighted.

4. Release the "Alt" key to enlarge the UserForm.

5. Toggle back to the Word document. To do this simply repeat steps 2 and 3. The difference is that this time you will stop when the Word document is highlighted. When the Word document is highlighted, release the "Alt" key to enlarge the Word document and bring it to the forefront.

References

• Oklahoma State: Using Windows Shortcut Keys
• SEO Consultants Directory: Windows Key Shortcuts