Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Userform otomatic to perceive
hi
Userform put on the two textbox.they are names textbox1 and textbox2. They are valeu's character length four if textbox2 selecting. what is userform events? ------------------------------------------------------- Private Sub UserForm_????????????() if len(textbox1)=4 then textbox2.setfocus end if End Sub ---------------------------------------------------- what ???? write ? |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Userform otomatic to perceive
Hi
Something like this: Private Sub TextBox1_Change() If Len(Me.TextBox1.Value) = 4 Then Me.TextBox2.SetFocus End Sub Regards, Per skrev i meddelelsen ... hi Userform put on the two textbox.they are names textbox1 and textbox2. They are valeu's character length four if textbox2 selecting. what is userform events? ------------------------------------------------------- Private Sub UserForm_????????????() if len(textbox1)=4 then textbox2.setfocus end if End Sub ---------------------------------------------------- what ???? write ? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Is there an easy Copy/Paste of a Userform ? (Entire Userform Including tx & cbx's) | Excel Programming | |||
Userform to enter values and shown in same userform in list | Excel Programming | |||
Looping procedure calls userform; how to exit loop (via userform button)? | Excel Programming | |||
Activating userform and filling it with data form row where userform is activate | Excel Programming | |||
Access from add_in userform to main template userform.... | Excel Programming |