Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 1
Default 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   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 1,533
Default 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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Is there an easy Copy/Paste of a Userform ? (Entire Userform Including tx & cbx's) Corey Excel Programming 2 January 9th 07 01:01 PM
Userform to enter values and shown in same userform in list helmekki[_104_] Excel Programming 0 November 19th 05 03:23 PM
Looping procedure calls userform; how to exit loop (via userform button)? KR Excel Programming 6 July 27th 05 12:57 PM
Activating userform and filling it with data form row where userform is activate Marthijn Beusekom via OfficeKB.com[_2_] Excel Programming 3 May 6th 05 05:44 PM
Access from add_in userform to main template userform.... Ajit Excel Programming 1 November 18th 04 05:15 PM


All times are GMT +1. The time now is 10:23 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"