Making splash screen

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
 
V

Vasant Nanavati

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

RB Smissaert

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
 
R

RB Smissaert

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

Vasant Nanavati

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