Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Set Tab Order in User form
Hi All, How can we set a Tab order in User form? what i mean is, If I hit tab on keyboard, I want the cursor to point to the field next to it. Thanks in Advance. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Set Tab Order in User form
Controls on a userform have two tab-related properties: TabStop which is a True/False boolean and TabIndex, which is an integer that controls which control gets focus as the Tab key is pressed. You can't have two controls that have the same TabIndex value, so it works best to start numbering them at the last control you would want to have focus and work your way back up to 1... BTW, if TabStop is False, you can't tab to that control. -- jamescox ------------------------------------------------------------------------ jamescox's Profile: http://www.thecodecage.com/forumz/member.php?userid=449 View this thread: http://www.thecodecage.com/forumz/sh...d.php?t=113134 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Set Tab Order in User form
hi Sam, Right click on the userform in the VBE & select Tab Order. You can see the 2 below links for more details: 'Excel -- UserForm With ComboBoxes' (http://www.contextures.com/xlUserForm02.html#Test) 'VBA for Excel Userforms' (http://www.excel-vba.com/vba-forms-3-1-creating.htm) hth Rob -- broro183 Rob Brockett. Always learning & the best way to learn is to experience... ------------------------------------------------------------------------ broro183's Profile: http://www.thecodecage.com/forumz/member.php?userid=333 View this thread: http://www.thecodecage.com/forumz/sh...d.php?t=113134 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Date field in user form & Loading a user form on opening workbook | Excel Programming | |||
User Form Tab Order | Excel Discussion (Misc queries) | |||
Tab order in a user form | Excel Programming | |||
Tab order on User Form not working | Excel Programming | |||
Control Order on User Form | Excel Programming |