Tab Order
 

I have several userforms in my spreadsheet. When I put the cursor in
the first textbox of the userform and press the tab key it may move to
the sixth textbox if I press it again it might go to the command
button.

How do I get my tab to scroll across my textboxes/ through the userform
in order?


--
oberon.black
------------------------------------------------------------------------
oberon.black's Profile: http://www.excelforum.com/member.php...o&userid=26732
View this thread: http://www.excelforum.com/showthread...hreadid=466617

Tab Order
 

Good afternoon Oberon.black

Select a control on the userform (eg, your textbox, spinner etc) an
have a look in the properties box for the tab index control. A ta
index value of 2 will follow the control that has a tab index of 1 an
so on, so go though each control on the form and set their tab inde
values.

HTH

Dominic

--
dominic
-----------------------------------------------------------------------
dominicb's Profile: http://www.excelforum.com/member.php...fo&userid=1893
View this thread: http://www.excelforum.com/showthread.php?threadid=46661

Tab Order
 

Hi Oberon,

With the userform selected in the VBE, select the Tab Order option on the
View menu.


---
Regards,
Norman



"oberon.black"
wrote in message
news:oberon.black.1v7cef_1126454727.0195@excelforu m-nospam.com...

I have several userforms in my spreadsheet. When I put the cursor in
the first textbox of the userform and press the tab key it may move to
the sixth textbox if I press it again it might go to the command
button.

How do I get my tab to scroll across my textboxes/ through the userform
in order?


--
oberon.black
------------------------------------------------------------------------
oberon.black's Profile:
http://www.excelforum.com/member.php...o&userid=26732
View this thread: http://www.excelforum.com/showthread...hreadid=466617

Tab Order
 

oberon, you can set the tab order for the objects on the user form, when in
the VBA editor press F4 to bring up the properties window there is a option
there for TabStop set them in the order you want

--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2002 & 2003

"oberon.black"
wrote in message
news:oberon.black.1v7cef_1126454727.0195@excelforu m-nospam.com...

I have several userforms in my spreadsheet. When I put the cursor in
the first textbox of the userform and press the tab key it may move to
the sixth textbox if I press it again it might go to the command
button.

How do I get my tab to scroll across my textboxes/ through the userform
in order?


--
oberon.black
------------------------------------------------------------------------
oberon.black's Profile:
http://www.excelforum.com/member.php...o&userid=26732
View this thread: http://www.excelforum.com/showthread...hreadid=466617

Tab Order
 

Perfecto!!!!

Than

--
oberon.blac
-----------------------------------------------------------------------
oberon.black's Profile: http://www.excelforum.com/member.php...fo&userid=2673
View this thread: http://www.excelforum.com/showthread.php?threadid=46661

Tab Order
 

Norman, never seen that, that is much easier

--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2002 & 2003

"Norman Jones" wrote in message
...
Hi Oberon,

With the userform selected in the VBE, select the Tab Order option on the
View menu.


---
Regards,
Norman



"oberon.black"
wrote in message
news:oberon.black.1v7cef_1126454727.0195@excelforu m-nospam.com...

I have several userforms in my spreadsheet. When I put the cursor in
the first textbox of the userform and press the tab key it may move to
the sixth textbox if I press it again it might go to the command
button.

How do I get my tab to scroll across my textboxes/ through the userform
in order?


--
oberon.black
------------------------------------------------------------------------
oberon.black's Profile:
http://www.excelforum.com/member.php...o&userid=26732
View this thread:
http://www.excelforum.com/showthread...hreadid=466617