The order is the same as the order of items under the Windows menu.

So if you want keystrokes only, ALT+W followed by the number of the window
to gain focus.

Cheers
Andy

--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info
"Bishop" wrote in message
...
CTRL+Tab seems to have no discernable order. It takes me from the the
code
for Form1 to Module3 to Module 7 to Form2 to code for Form3 so on and so
forth. How do I set the tab order?

"Andy Pope" wrote:

Hi,

Once you have the code window open you could use CTRL+TAB to return to
it.

F7 on a userform will take you to an event of the active control.

Cheers
Andy

--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info
"Bishop" wrote in message
...
When I pull up a Form and press F7 to see the code VBE will
automatically
add:

Sub BlahBlah_Click ()

End Sub

to the bottom of my existing code. How do I make this stop?