IFM SplashScrn

When you have made that project that you are proud of and want to give it that finishing touch then why not give it a professional view and finish it off with a splash screen.

Here is one of many ways to get a professional looking splash screen.

The key to this is to remove the Top caption or Title area. If you have a look at all applications that have a splash screen you will see that they have no Top caption

(see image1)

The following technique has these basics that you can use in your splash screens.

1) No Top Caption

2) Hides application, so that all that is viewed is your splash screen

3) Fades in, waits a few secs then fades out with a new image.

4) Closes the userfrom and then loads up your spreadsheet.

Note: This routine also includes a Disabled sheet that only displays if macros are disabled. (See image2)

All you need is to design your Userform and add images etc, then use via import the 3 modules into your project.

Have a play around with what you can do...... just bare in mind who & what the splash screen is for ... i.e will your users benifit from it (Telling them what is happening etc)

In fact, with this type of splash screen I would put in an option to either show/not show when next opening........or abilty to escape the screen.....simple enougth to put in.

The WorkBook example below gives you 5 examples on doing this plus an all in one example that you can use straight off in your work book.

Amendment 25th July 2006

Thanks to David Baker, minor error in workbook close and sheet2 Activate code, was actually Sheet1.Activate, thanks David!