Hi I`ve had some great help on a user form from Audiojoe today. I`ve come quite far but there are still a few things I can`t seem to figure out.
I`ve made a userform for data entry purposes.
Each textbox must be filled with 5 figures however sometimes the input is e.g. 321 What I want is that on tab (swith to the next textbox 00321 is filled in.
How can I get the form to do that?
Also what I would like is that when someone filles in 5 figures in the first textboxt, the cursor automatically switches to the next box.
My current source for a textbox:
Private Sub TBL1_Change()
Worksheets("sheet1").Range("B2").Value = TBL1
End Sub
Can anyone hand me some clue`s?
thanks.
Dinictus.
Holland
This message was edited by Dinictus on 2002-03-20 07:01
I`ve made a userform for data entry purposes.
Each textbox must be filled with 5 figures however sometimes the input is e.g. 321 What I want is that on tab (swith to the next textbox 00321 is filled in.
How can I get the form to do that?
Also what I would like is that when someone filles in 5 figures in the first textboxt, the cursor automatically switches to the next box.
My current source for a textbox:
Private Sub TBL1_Change()
Worksheets("sheet1").Range("B2").Value = TBL1
End Sub
Can anyone hand me some clue`s?
thanks.
Dinictus.
Holland
This message was edited by Dinictus on 2002-03-20 07:01