Animated gif - Userform

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

"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."

Here is an example that he gives:
Download now..............

Here is the Addin to make it happen in your spreadsheet. You will also need to put the code from the example into your spreadsheet and the form.
Download now

Day and Date Calculator

http://blog.livedoor.jp/andrewe/archives/cat_415504.html

Here's something I was playing with over the break. (Thanks to my trusty tester Remco :-))

Day and Date Calculator
You can subtract dates. (The difference between the 2 dates is shown under the "Years, Month, Day" and "Weeks, Day" labels which adjust automatically. Note: The Upper Date must be higher than the Lower Date)



Or calculate dates. (Enter either positive or negative numbers in the textboxes where applicable. The "Calculated Date" label also updates automatically)



Pre-1900 Dates
Notice the lower date from the first image that is shown is Year 100. Dates from Year 100 January 1 until Year 9999 November 30 can be used for both Subtract Dates and Calculate Dates.

Here's a link to download from.