form question

[macamarr]

is it possible to have an animated gif work on a form? If
so how?

 

[Bill Lunney]

Not possible with the default Excel image control etc. You will need to use
a 3rd party ActiveX control. Alternatively you could use the Internet
Explorer component. However this will add a bit of bulk and an extra
dependency to your solution.


--

Regards,


Bill Lunney
www.billlunney.com

 

[Bill Lunney]

As a more complete follow up. Add the IE control to your form/sheet and use
something like:
With Me.WebBrowser1
.Navigate ("c:\911heaven.gif")
End Withto display the
image.http://www.billlunney.com/Excel/FAQ/DisplayFAQ.ascx?ExcelFAQID=34

--

Regards,


Bill Lunney
www.billlunney.com