user form parameters

[Alberto Ast]

Where can I learn how to set up the user form parameters

I have a user form with three text boxes but when I click tab I do not know
how to control the next text box to go.

Then I have a commandbuttom which I expect user to click but would like to
be able to skip the buttom and just accept the enter to execute macro.

Can I do it?

 

[OssieMac]

In the Userform design mode, right click the text box and select properties.

You will find 3 properties. Tab Index, TabKeyBehaviour and TabStop

TabIndex starts at zero for the first stop. Set the Numeric 0 to 2 for each
of the 3 textboxes in the required order.

TabKeyBehaviour = False. Tab advances to next control.
TabKeyBehaviour = True. Tabs within the control. (Use Enter to advance to
next control)

TabStop = True. Cursor will stop in the control with Tab or Enter.
TabStop = False. Cursor will skip the control with Tab or Enter but you
can still select the control with the mouse.