Hi,

Using Excel 2000 on Windows 2000 Professional,

I'm using the following code to tab to the next textbox on a
worksheet. When I exit the design mode and press tab in the textbox,
the destination textbox disappears. The cursor is there but I can't
see it. Is there any way to keep the cursor visible?

Thanks,

Dan

Private Sub TextBox3_KeyDown(ByVal KeyCode As MSForms.ReturnInteger,
ByVal Shift As Integer)
''' Check if the TAB or ENTER key was pressed.
If KeyCode = vbKeyTab Or KeyCode = vbKeyReturn Then
''' If this is Excel 97 you must select a cell
''' before attempting to activate another control.
If Val(Application.Version) < 9 Then
Me.Range("A1").Select
End If
''' Move the focus appropriately.
If CBool(Shift And 1) Then
''' The user was holding down the SHIFT key
''' move back to the previous control.
TextBox3.Activate

Else
''' Move to the next control.
TextBox4.Activate

End If
End If
End Sub