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

Best way to learn Power Query?
Read M is for (Data) Monkey book by Ken Puls and Miguel Escobar. It is the complete guide to Power Query.

Forum statistics

Threads
1,223,237
Messages
6,170,928
Members
452,366
Latest member
TePunaBloke

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
Back
Top