View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Nigel Nigel is offline
external usenet poster
 
Posts: 923
Default Loading a Userform

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

--
Cheers
Nigel



"Jason Zischke" wrote in message
...
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