View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Matt Jensen[_2_] Matt Jensen[_2_] is offline
external usenet poster
 
Posts: 5
Default "Tabbing" code crashing xl2002 WinXP

Howdy
Put 2 control toolbar text boxes on a worksheet named Textbox1 and
TextBox2.
Then in the code for the same sheet put this code:

Private Sub Textbox1_KeyDown(ByVal KeyCode As MSForms.ReturnInteger,
ByVal Shift As Integer)
If KeyCode = 9 Then
If Shift 0 Then
'nothing
Else
Worksheets("Sheet1").Range("A1").Activate
TextBox2.Activate
End If
End If
End Sub


When not in design mode, you click in TextBox1 and hit the 'tab' key
xl2002 on WinXP crashes for me.

Anyone know any code that will work on both 97 and 2002 for tabbing
between boxes?
Thanks
Matt