Loading a Userform

J

Jason Zischke

Hi All,

I have a form that shows for about 5 seconds then unloads however when it
shows up the form is just white is there a way for it to show the info on it
my code is below,can someone help me?

Jason

Sub ShowForm()
Userform1.Show
End Sub

Dim MyTime
Private Sub UserForm_Activate()
MyTime = Time
x = MyTime
y = 0
MyNum = TimeValue("00:00:05")
Do Until y = 1
Z = x + MyNum
If x + MyNum <= MyTime Then
y = 1
End If
MyTime = Time
Loop
If y = 1 Then
UserForm1.Hide
End If
End Sub
 
N

Nigel

Try putting your delay code into the userform initialize event instead. You
also hide the form, this does not unload it. Note: you could more simply use
OnTime to initiate the delay e.g.

' in the user form code put this.....

Private Sub UserForm_Initialize()
Application.OnTime Now + TimeValue("00:00:05"), "fm_UnLoad"
End Sub


' in a standard module use these to load / unload the form

Sub fm_load()
UserForm1.Show
End Sub

Sub fm_UnLoad()
Unload UserForm1
End Sub
 
B

Bob Phillips

Try this

Private Sub UserForm_Activate()
MyTime = Time
x = MyTime
y = 0
MyNum = TimeValue("00:00:05")
Me.Repaint
Do Until y = 1
Z = x + MyNum
If x + MyNum <= MyTime Then
y = 1
End If
MyTime = Time
Loop
If y = 1 Then
UserForm1.Hide
End If
End Sub



--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top