"tabbing" from one element to the other

[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!

[Leith Ross]

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

[schoujar]

thats what I would have thought. But my properties window doesn't even show the tabindex and tabstop properties. Whats wrong?

By the way these elements are not on a form. They are individually placed on a worksheet. Would that be a problem?