Using VBA to move from one text box to another

[BLevie]

I have a worksheet that is made up of numerous text boxes and check boxes. I
want to simulate the tab function by jumping from the current text box to the
next one in line.

I tried to use the exp.setfocus command but it gives me a error.

I cannot find tab order or tab index in the properties field.

Any help is appreciated. Thank you in advance

 

[Daniel.C]

Try :

Private Sub TextBox1_LostFocus()
ActiveSheet.TextBox2.Activate
End Sub

HTH
Daniel