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

Excel Joke
Why can't spreadsheets drive cars? They crash too often!

Forum statistics

Threads
1,220,965
Messages
6,157,119
Members
451,399
Latest member
alchavar

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