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.


"RB Smissaert" wrote in message
...
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

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

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

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

"Vasant Nanavati" <vasantn *AT* aol *DOT* com wrote in message
...
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.


"RB Smissaert" wrote in message
...
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

Thanks.
Will have a look at that.

RBS

wrote in message
...
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.
--------------------------------------------------------------------------
------------------------------------

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

"RB Smissaert" wrote in message
...
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

"Vasant Nanavati" <vasantn *AT* aol *DOT* com wrote in message
...
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.


"RB Smissaert" wrote in message
...
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