Using VBA to move from one text box to another

B

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
 
D

Daniel.C

Try :

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

HTH
Daniel
 
Top