Can you display animated gifs on a userform?

[DRJ]

topic

 

[elgringo56]

Some time ago, some of us tried to figgure out a way to do just this and came to the conclusion that no, you cant. It seems that while a user form is in show, it is actually running, and in excel, only one thing can run at a time. Sorry

 

[Tom Urtis]

Consider:

Dialog example using pictures from Ole Erlandsen
http://www.erlandsendata.no/english/index.php?d=endownloaduserforms

or placing a WebBrowser control on your userform and pointing it to the url where the animated gif exists.

 

[Hero-0952]

Also, if you have access to Flash you can play a Flash movie on a Userform.


Of course this becomes a lot more involved as you will need to have a player installed on the user-end and the Flash .swf will need to reside in the same directory as the xls.

 

[Ivan F Moala]

Also, if you have access to Flash you can play a Flash movie on a Userform.


Of course this becomes a lot more involved as you will need to have a player installed on the user-end and the Flash .swf will need to reside in the same directory as the xls.

Hi Scott !! How are you my friend.

Also look here for an example from Scott (Flash) and en example using the WebBrowser control....

Splash screen using Flash macromedia
http://www.xcelfiles.com/Downloads_01.html


Userform animation
http://www.xcelfiles.com/Downloads_02.html

 

[Hero-0952]

Ivan,

Hi!! - I will email.
Thank you for the note!!

Scott

 

[DRJ]

I think the web browser control will work great since the url can point to a local file. Thanks for the help.

 

[HWL]

Animate with macro

I know this is an old post, but couldn't you in theory simulate animation by showing say, 3-10 different pictures in same position, with a macro?

Ideas???

 

[ENEMALI]

check this link but they could be other better methods which i dont know

www.vbaexpress.com/kb/getarticle.php?kb_id=19