Userform is not visible/does not show up if there is a code assigned to it as it load

[pedie]

Here's current code...
Is it not showing my form because 'm assigning a code to run as it Initialize?

I just dont know what to do....Please advice.

Thanks in advance.

[/FONT]
[FONT=Courier New]Option Explicit
Sub StartFalhLoop()
Call ShockwaveFlash1.LoadMovie(0, CurDir + "/vbSample.swf")
Me.ShockwaveFlash1.Movie = "E:\Personal_Files\Recent\DownloadedFile.swf"
End Sub
Sub StopFalhLoop()
Call ShockwaveFlash1.LoadMovie(0, CurDir + "/vbSample.swf")
Me.ShockwaveFlash1.Movie = ""
End Sub
Private Sub UserForm_Initialize()
 StartFalhLoop
 Me.StatusL.Caption = "Running code one..."
 Me.Repaint
 Application.Wait Now + TimeValue("00:00:02")
 Run "Mycode1"
 Unload Me
End Sub

 

[pedie]

I think no one show this... Please h.e.l.p . . .

 

[Norie]

Why are you unloading the form in the userform Initialize event.

As far as I know the userform doesn't actually display until the code in that event is completed.

But the last command you have tells VBA to unload it, so there's nothing to display.

I'm pretty sure that isn't what you want to do but I'm not sure what you actually want to do.

 

[kpark91]

Take "Unload Me" out of your Initialize sub.

 

[pedie]

That did the work! thanks alot for your help!

 

[pedie]

Norie, thanks...i didnt see your comments earlier....that makes sense...Thanks again