I can't get the tab indexing to work correctly on a user form.

I have a user form with two frames.
the first frame has two combo boxes and a text box, and three labels.
The labels are not indexed, and their tabstop property is set to False.
The other controls tab indexes are set to 0, 1 and 2 respectively.
the first combobox in this frame has focus set when the form is loaded.

the second frame has three text boxes and three labels.
Again, the labels tabstop property is set to False, and the textboxes tab
indexes are set to 0, 1, and 2.

When I tab through, I have to hit the tab key 3 extra times before the
cursor will move from the last text box in the first frame to the first
textbox in the second frame. I'm not sure where those three "tabs" are going
to, as the blinking cursor dissappears until it shows again in the textbox on
the second frame.

How can I make the tab go from the last text box in the first frame directly
to the first textbox in the second frame?

Hi Mim,

Are you sure you don't have any other controls like OK and/or Cancel
buttons that can take the focus when you tab? If you want the Tab key to
only cycle through the controls you mention, you have to be sure that any
other controls on the form that can take focus have their TabStop property
set to False.

--
Rob Bovey, Excel MVP
Application Professionals
http://www.appspro.com/

* Take your Excel development skills to the next level.
* Professional Excel Development
http://www.appspro.com/Books/Books.htm

"Mim" wrote in message
...
I can't get the tab indexing to work correctly on a user form.

I have a user form with two frames.
the first frame has two combo boxes and a text box, and three labels.
The labels are not indexed, and their tabstop property is set to False.
The other controls tab indexes are set to 0, 1 and 2 respectively.
the first combobox in this frame has focus set when the form is loaded.

the second frame has three text boxes and three labels.
Again, the labels tabstop property is set to False, and the textboxes tab
indexes are set to 0, 1, and 2.

When I tab through, I have to hit the tab key 3 extra times before the
cursor will move from the last text box in the first frame to the first
textbox in the second frame. I'm not sure where those three "tabs" are
going
to, as the blinking cursor dissappears until it shows again in the textbox
on
the second frame.

How can I make the tab go from the last text box in the first frame
directly
to the first textbox in the second frame?

Hi Rob,
I do have two buttons on the form as well. I tried setting their tabstops to
False, but still get the same results.

"Rob Bovey" wrote:

Hi Mim,

Are you sure you don't have any other controls like OK and/or Cancel
buttons that can take the focus when you tab? If you want the Tab key to
only cycle through the controls you mention, you have to be sure that any
other controls on the form that can take focus have their TabStop property
set to False.

--
Rob Bovey, Excel MVP
Application Professionals
http://www.appspro.com/

* Take your Excel development skills to the next level.
* Professional Excel Development
http://www.appspro.com/Books/Books.htm

"Mim" wrote in message
...
I can't get the tab indexing to work correctly on a user form.

I have a user form with two frames.
the first frame has two combo boxes and a text box, and three labels.
The labels are not indexed, and their tabstop property is set to False.
The other controls tab indexes are set to 0, 1 and 2 respectively.
the first combobox in this frame has focus set when the form is loaded.

the second frame has three text boxes and three labels.
Again, the labels tabstop property is set to False, and the textboxes tab
indexes are set to 0, 1, and 2.

When I tab through, I have to hit the tab key 3 extra times before the
cursor will move from the last text box in the first frame to the first
textbox in the second frame. I'm not sure where those three "tabs" are
going
to, as the blinking cursor dissappears until it shows again in the textbox
on
the second frame.

How can I make the tab go from the last text box in the first frame
directly
to the first textbox in the second frame?

"Mim" wrote in message
...
Hi Rob,
I do have two buttons on the form as well. I tried setting their tabstops
to
False, but still get the same results.

Hi Mim,

I've just set up a UserForm exactly as you describe, including the two
buttons. After setting the TabStop properties of the two buttons to False
the Tab key only cycles through the controls inside the two frames. Are you
sure you have the TabStop properties of the two buttons set to False and
that there are no other controls on the form that could take the focus?

--
Rob Bovey, Excel MVP
Application Professionals
http://www.appspro.com/

* Take your Excel development skills to the next level.
* Professional Excel Development
http://www.appspro.com/Books/Books.htm