Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Tab order in a user form
When you set the Tab Index in the Properties area for a ComboBox/TextBox etc.
Is there a way to have a box skipped? I have 4 boxes plus an OK and Cancel button. I would like to have the Tab order of the boxes be as follows: 1 skip 2 3 4 OK Cancel. Can I do that? |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Tab order in a user form
TimN schreef: When you set the Tab Index in the Properties area for a ComboBox/TextBox etc. Is there a way to have a box skipped? I have 4 boxes plus an OK and Cancel button. I would like to have the Tab order of the boxes be as follows: 1 skip 2 3 4 OK Cancel. Can I do that? If I understand it right you must have the order : 1 3 4 OK Cancel 2(skip) So you look at the userform in your editor, then you put you cursor on object 1, and in the properties you put TabIndex on 0, then you go to object 3 and you select Tabindex and put it on 0 again, then you go to object 4.... etc... automatically Object 2 will get the highest Tabindex and won't be selected because object OK and object Cancel are in between... I hope this works good enough for you ? Greetings, Baj |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Tab order in a user form
Private Sub TextBox2_Enter() Me.TextBox3.SetFocus End Sub -- HTH Bob Phillips (replace somewhere in email address with gmail if mailing direct) "TimN" wrote in message ... When you set the Tab Index in the Properties area for a ComboBox/TextBox etc. Is there a way to have a box skipped? I have 4 boxes plus an OK and Cancel button. I would like to have the Tab order of the boxes be as follows: 1 skip 2 3 4 OK Cancel. Can I do that? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
User Form Tab Order | Excel Discussion (Misc queries) | |||
Tab order on User Form not working | Excel Programming | |||
How to: User Form to assign a user defined range to a macro variab | Excel Programming | |||
Control Order on User Form | Excel Programming |