Make User form/Splash screen appear sooner

Noir · May 25th, 2002, 09:07 PM

I used as user form to create a splash screen and it works perfectly. The only problem is, the splash screen doesn't appear until 20-25 seconds after i open workbook.

Is there any way i can make the user form/splash screen appear as soon as i open the workbook?

Thnx,
Noir

James · May 25th, 2002, 09:20 PM

Hi Noir,

The UserForm "splash screen" will only show after the Workbook is fully opened, but 20-25 secs.To open?. You might want to post some of your code on how your going about this.

Regards,
James

Noir · May 25th, 2002, 09:51 PM

Hi James,
Thanks for the tip. I have another question.

Is it possible to add color to the text of the UserForm/Splash screen?

Noir

James · May 25th, 2002, 09:57 PM

Noir,

Have a look in the VBE properties of your UserForm, you have the control to change almost everything.

Regards,
James

Noir · May 26th, 2002, 05:46 AM

I found it!

Thanks again James.

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

May 25th, 2002, 09:07 PM	#1
Noir Board Regular Join Date: Mar 2002 Posts: 364	I used as user form to create a splash screen and it works perfectly. The only problem is, the splash screen doesn't appear until 20-25 seconds after i open workbook. Is there any way i can make the user form/splash screen appear as soon as i open the workbook? Thnx, Noir

May 25th, 2002, 09:20 PM	#2
James Board Regular Join Date: Feb 2002 Location: Huntington Beach, CA USA Posts: 327	Hi Noir, The UserForm "splash screen" will only show after the Workbook is fully opened, but 20-25 secs.To open?. You might want to post some of your code on how your going about this. Regards, James

May 25th, 2002, 09:51 PM	#3
Noir Board Regular Join Date: Mar 2002 Posts: 364	Hi James, Thanks for the tip. I have another question. Is it possible to add color to the text of the UserForm/Splash screen? Noir

May 25th, 2002, 09:57 PM	#4
James Board Regular Join Date: Feb 2002 Location: Huntington Beach, CA USA Posts: 327	Noir, Have a look in the VBE properties of your UserForm, you have the control to change almost everything. Regards, James

May 26th, 2002, 05:46 AM	#5
Noir Board Regular Join Date: Mar 2002 Posts: 364	I found it! Thanks again James.