How to tab between text-boxes?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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

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