VBA - Excel TabIndex?

[Funkymatt]

I have two text boxes and I want to tab between them in Excel. Sheet1.TextBoxGrp.TabIndex does not exist as a method? How can I accomplish this?

 

[acron]

If you have a TextBox1 and TextBox2 the following code will Tab from TextBox1 to TextBox2 :

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

You can repeat the same idea for the second TextBox. Right click on the sheet with the TextBoxes, select View Code and enter the code in the resultant code pane.

A.C.