Excel

Animated gif - Userform

Ivan F Moala

Visits here

Greatest place to be

Thanks for visiting my site lucky visitor:

This page was last updated on: March 15, 2008

Need to use an animated gif on a userform?

If you looked around the Net or here you would realize that you either need

1) A dll control for this OR

2) MS web browser control.

3) or some other ActiveX control.

Either way if you were to distribute your workbook, you needed to include other files, weather that is the dll or the actual gif files. So when ever you gave out this file to someone else they needed these files.

Using the WebBrowser control.

Here is a way that gets around this by actually reading the gif file data from a sheet and creating the gif file. This is then referenced via the html coding to load up your gif file. Also included in the html code is the ability to;

1) Take away the scroll bars from the webbrowser control (There is no way to do this with the control itself!? only via html coding)

2) Resize & position the image file (see below) This is useful if you just want to view the actual gif file and NO useless white space.

You could use this in your own application like this (See below)

Here is an Example workbook that includes data for 6 gif files.

Download now..............

Download this Addin to generate the gif data so you can incorporate it into your own routines. The Addin will generate the gif file data for you.

Updated 24 April 2007

Download now

This page was created 27th December 2004

If you have found this file useful then consider donating. Why Donate ?

Can Do

Want to print out your animated creation for all to see? If you buy Xerox Phaser ink at online prices, you can do just that! You can find cheap HP toner cartridges online at prices lower than at those office superstores. Whether your preference is HP, Dell or just discount Lexmark toner cartridges, you'll find what you need online.