Excel to Play Flash Animation or GIF in User Form???

[Shaka215]

I am just woundering if its possiable to have a flash animation video
play in a VB Form in Excel. I like to create a user form that appears
when someone opens my program with usually some sort of graphic work
(makes my programs look more professional). I have been working on a
particular project for awhile now and would like to WOW the end-user
when they use my program by having a flash video play when the program
(workbook) starts up...anyone know how to get a flash video to play in
a VB User form??? If not flash then is it possiable to do this with a
GIF image? Much appreciated!!!

 

[Graham Whitehead]

try this: http://www.xcelfiles.com/AnimatedGif.html

 

[Shaka215]

This isn't working for me...I tried what you did and I just get the DO
NOT mouse icon...

 

[Robert Bruce]

I am just woundering if its possiable to have a flash animation video
play in a VB Form in Excel. I like to create a user form that appears
when someone opens my program with usually some sort of graphic work
(makes my programs look more professional). I have been working on a
particular project for awhile now and would like to WOW the end-user
when they use my program by having a flash video play when the program
(workbook) starts up...anyone know how to get a flash video to play in
a VB User form??? If not flash then is it possiable to do this with a
GIF image? Much appreciated!!!

You can show an animated GIF on a form by using the WebBrowser control
that's installed with IE. Just use the Navigate2 method of the control to
open the GIF file.

Alternatively, you could experiment with adding a ShockwaveFlash object to
your form. No idea how you would make this work as I've never tried it, but
since it works OK with IE, I don't see why you couldn't make it work on an
MSForms form.

HTH

Rob

 

[Robert Bruce]

Alternatively, you could experiment with adding a ShockwaveFlash
object to your form. No idea how you would make this work as I've
never tried it, but since it works OK with IE, I don't see why you
couldn't make it work on an MSForms form.

Just taken a look at this out of interest.

Dragged a ShockwaveFlash object onto my form, set the movie property of the
object to the full path to my .swf file, ran the form. Worked perfectly.

Rob