Set Tab Order in User form

[sam]

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.

 

[jamescox]

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.

 

[broro183]

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