LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 15
Default Userform problem

Sorry... I'm sort of reposting this since I received no answer from my first
post. This time I will show some sample code.

I have 3 userforms:

'Userform1
Private Sub CommandButton1_Click()
userform2.Show
End Sub


'Userform2
Private Sub CommandButton1_Click()
userform2.Hide
End Sub

Private Sub TextBox1_Change()
If TextBox1.TextLength = 4 Then
If TextBox1.Text = "5555" Then
userform2.Hide
userform1.Hide
Userform3.Show
End If
End If
End Sub

'Userform3
Private Sub CommandButton2_Click()
Userform3.Hide
userform1.Show
End Sub

When I click the commandbutton1 on userform1 it shows userform2, when I type
"5555" into textbox1 then userform3 shows and userform1 and 2 hide, if I
click Commandbutton2 on Userform3, Userform3 hides and Userform1 shows...
the problem is if I try to do the same sequence again. The textbox1 events
don't work the second time.
Do anyone know why this is happening, and does someone know how to make this
work?
Thanks in Advance... and sorry again for the repost!

Craig



 
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
Userform problem? law Excel Discussion (Misc queries) 0 December 3rd 07 07:54 PM
Userform problem racudd Excel Programming 2 April 14th 06 10:30 PM
userform problem Pierre via OfficeKB.com[_2_] Excel Programming 3 October 14th 05 03:08 PM
Userform from a Userform Problem Adrian Excel Programming 1 October 12th 05 04:57 PM
UserForm Problem mayuss Excel Programming 3 August 9th 04 01:18 PM


All times are GMT +1. The time now is 09:56 PM.

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

About Us

"It's about Microsoft Excel"