Tab Order On A UserForm
 

Greetings,

I have a UserForm (UF1) with a Frame (Frame1), 3 ComboBoxes (CBox1,
CBox2 and CBox3) and 3 CommandButtons (New, Save and Cancel). "NEW"
brings u[ a second UserForm (UF2). The tab order on UF1 is set to go
from CBox1 to CBox2. Then to Frame1. Though the 3 TextBoxes and
back to CBox3.

The first problem is that the focus does not go to the first TextBox
on Frame1 from CBox2, it goes to the next visible control which is the
"Save" button (CBox3 and the "New" button are not visible until the
cursor exits the last TextBox inside of Frame1)

The second problem is in coming from UF2 the cursor goes not to CBox3,
the back to CBox1.

Any help would be most appreciated.

TIA

-Minitman

Tab Order On A UserForm
 

Minitman

Are you sure you have your Tab Order set properly? It worked for me. Right
click on the userform and choose Tab Order and make sure everything's in the
right order. Then right click on the Frame and make sure those are in the
right order.

Can you restate the second problem, I'm not sure I understand it.

--
Dick Kusleika
MVP - Excel
Excel Blog - Daily Dose of Excel
www.dicks-blog.com

"Minitman" wrote in message
...
Greetings,

I have a UserForm (UF1) with a Frame (Frame1), 3 ComboBoxes (CBox1,
CBox2 and CBox3) and 3 CommandButtons (New, Save and Cancel). "NEW"
brings u[ a second UserForm (UF2). The tab order on UF1 is set to go
from CBox1 to CBox2. Then to Frame1. Though the 3 TextBoxes and
back to CBox3.

The first problem is that the focus does not go to the first TextBox
on Frame1 from CBox2, it goes to the next visible control which is the
"Save" button (CBox3 and the "New" button are not visible until the
cursor exits the last TextBox inside of Frame1)

The second problem is in coming from UF2 the cursor goes not to CBox3,
the back to CBox1.

Any help would be most appreciated.

TIA

-Minitman