"tabbing" from one element to the other

  • Thread starter Thread starter schoujar
  • Start date Start date
S

schoujar

I have a spreadsheet with a few combo boxes and text boxes on it. I want
that when the user is using control1 by pressing the tab key he should
be switched to control2. For some reason .setFocus and .Activate are
nto working!

Please help!
 
Hello schoujar,

In the properties sheet for the controls you will find TabIndex and
TabStop. TabIndex is a sequential number that is assigned to a control
when it is created. It has a companion property TabStop that is a
boolean value (True/False). If TabStop is True, the control will
receive the focus when the user press the Tab key. The order in which
Tabbing occurs is set by TabIndex. It starts at 0 and increases by 1.
You can reset the TabIndex of the controls to match your layout.

Sincerely,
Leith Ross
 
Hello schoujar,

In the properties sheet for the controls you will find TabIndex an
TabStop. TabIndex is a sequential number that is assigned to a contro
when it is created. It has a companion property TabStop that is
boolean value (True/False). If TabStop is True, the control wil
receive the focus when the user press the Tab key. The order in whic
Tabbing occurs is set by TabIndex. It starts at 0 and increases by 1
You can reset the TabIndex of the controls to match your layout.

Sincerely,
Leith Ros
 
thats what I would have thought. But my properties window doesn't eve
show the tabindex and tabstop properties. Whats wrong?

By the way these elements are not on a form. They are individuall
placed on a worksheet. Would that be a problem
 
Back
Top