Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss

moving between textboxes..

1 view
Skip to first unread message

Maria

unread,
Sep 11, 2001, 1:45:10 PM9/11/01
to
Hello !

I have seven textboxes on a worksheet...

I would like to use Tab to go from textbox to textbox - and have tried to
use KeyPress og KeyDown, but don't have enough knowledge to do this...

Anyone who can help me ??

Yours
Maria


Harald Staff

unread,
Sep 12, 2001, 4:23:05 AM9/12/01
to
Hi Maria

If Excel 2000:

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

If Excel 97:

Private Sub TextBox1_KeyDown(ByVal KeyCode As MSForms.ReturnInteger, _
ByVal Shift As Integer)
If KeyCode = 9 Then
Cells(1, 1).Select
TextBox2.SelStart = 0
TextBox2.SelLength = Len(TextBox2.Text)
TextBox2.Activate
End If
End Sub

HTH. Best wishes Harald
Maria <mar...@start.no> skrev i
news:G4sn7.13448$em.3...@juliett.dax.net...

Maria

unread,
Sep 12, 2001, 10:08:56 AM9/12/01
to
Tusen takk !!

Dette har jeg grublet lenge på.. :-)

hilsen
Maria


"Harald Staff" <harald...@nrk.no> wrote in message
news:#QCLnQ2OBHA.2080@tkmsftngp05...

0 new messages