Animated 'GIF' UserForm

lpumxm3

New Member
Joined
Jan 9, 2014
Messages
2
Hi All,

Basically I have a user form with the webbrowser that shows my loading screen animation without problems.

Now when I try to combine it with my code, userform shows but animation is static..its not running! Maybe enableevents needs to be = true? I have it to false.. here is the code for the form

Private Sub UserForm_Initialize()
Me.WebBrowser1.Navigate "C:\Users\lpumxm3\Desktop\cool.gif"
End Sub


Private Sub WebBrowser1_DocumentComplete(ByVal pDisp As Object, URL As Variant)
Me.WebBrowser1.Document.Body.Scroll = "no"
End Sub

Private Sub Workbook_Open()
UserForm1.Show vbModeless
End Sub

All of this above is working!

UserForm1.Show vbModeless
DoEvents

'my code

Unload UserForm1

this is where it shows in the code, but animation is not running!

Any help would be appreciated. I ve been searchign around and can't find anything that would work!

Cheers,

Marko
 

Excel Facts

Lock one reference in a formula
Need 1 part of a formula to always point to the same range? use $ signs: $V$2:$Z$99 will always point to V2:Z99, even after copying
Master Excel Bundle

Excel contains over 450 functions, with more added every year. That’s a huge number, so where should you start? Right here with this bundle.

Forum statistics

Threads
1,151,979
Messages
5,767,432
Members
425,412
Latest member
andrealp4444

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top