Moving through fields in an Excel form

[Pete Soulis]

Is there a way to move in a form created with Excel 2002
from one field to the next and back again? (Something
like pressing "TAB" or a different keystroke)

 

[Bob Phillips]

Pete,
You can use Tab, and Shift-Tab, and organise the order with the TabIndex
property.

 

[Pete Soulis]

Where exactly is this "TabIndex Property"?

-----Original Message-----
Pete,
You can use Tab, and Shift-Tab, and organise the order with the TabIndex
property.

--

HTH

Bob Phillips




.

 

[Bob Phillips]

Pete,

In the VB IDE, get the form up, and make sure that menu View>Properties is
enabled, and you will see a list of properties in that window. Select any
control, and you will see that one of the items in the Properties window is
TabIndex. You can set it from there.