Making splash screen

  • Thread starter Thread starter RB Smissaert
  • Start date Start date
R

RB Smissaert

Could anybody tell me or point me in the right direction how to make a
splash screen like the one of Andrew Baker's Excel Workbook Rebuilder? It is
for an add-in, based on a userform.
Thanks for any advice.

RBS
 
Hi RBS:

I must be missing something, because knowing your level of knowledge, this
should not be difficult for you. It weould seem that all you need is to set
the UserForm's Picture property to whatever you want, slap on a makeshift
progress bar, and dismiss the form using the OnTime method.

To get rid of the TitleBar on the UserForm, look at the code behind FormFun
on Stephen Bullen's site:

http://www.bmsltd.co.uk/excel/default.htm

Is there a specific aspect of this that you are finding problematical?

Regards,

Vasant.
 
Vasant,

Haven't actually tried doing this yet and perhaps it is easy indeed.
I thought that the way the title moved into view could be somewhat
difficult.
Have you actually seen this particular splash screen?

RBS
 
Thanks.
Will have a look at that.

RBS

John Walkenbach : Creating a "Splash Screen" for a Workbook
http://www.j-walk.com/ss/excel/tips/tip39.htm

HTH
Paul
-------------------------------------------------------------------------- ------------------------------------
Be advised to back up your WorkBook before attempting to make changes.
-------------------------------------------------------------------------- ------------------------------------
Click to expand...
 
Hi RBS:

I've seen the splash screen but I don't remember the title moving into view.
Perhaps I was looking at a different version. I'll take another look.

Regards,

Vasant.
 
Back
Top