Moving through fields in an Excel form

P

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)
 
B

Bob Phillips

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

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




.
 
B

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.
 
Top