| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to change series plotting order without changing legend order? | Charts and Charting in Excel | |||
| For chart syles, why doesn't color order match series order? | Charts and Charting in Excel | |||
| How stop Excel file UK date order changing to US order in m.merge | Excel Discussion (Misc queries) | |||
| Daily Macro to Download Data, Order and paste in order | Excel Worksheet Functions | |||
| Daily Macro to Download Data, Order and paste in order | Excel Programming | |||
![oberon.black[_36_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Hybrid Mode
