How to tab between text-boxes?

[SOSK]

When I enter text into text-boxes, I want to be able to jump from one textbox to another simply by using the tab button
Is this possible? Is it also possible to decide in which order to jump? The textboxes are created using the design view and they have no code attached

Thank

 

[Harald Staff]

Textboxes on a worksheet ? You have to program it for each and every box.
Rightclick the box, "view code", paste this in:

Private Sub TextBox1_KeyDown(ByVal KeyCode _
As MSForms.ReturnInteger, ByVal Shift As Integer)
If KeyCode = 9 Then TextBox2.Activate
End Sub

(This will err in Excel97 due to a minor bug)
--
HTH. Best wishes Harald
Followup to newsgroup only please

When I enter text into text-boxes, I want to be able to jump from one

textbox to another simply by using the tab button.

Is this possible? Is it also possible to decide in which order to jump?

The textboxes are created using the design view and they have no code
attached.