View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Vasant Nanavati Vasant Nanavati is offline
external usenet poster
 
Posts: 1,080
Default Making splash screen

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