creating a simple startup form?

[adelene]

Hi

How do i create a userform which appears when excel is loaded?

like a intro that you sometimes see with applications...

i know there is some vb i have to insert into the form and elsewhere...

 

[Smitty]

See this MSKB article: How to Create a Startup Screen with a UserForm.It's commonly referred to as a "Splash Screen".

John Walkenbach has a similar method here: http://www.j-walk.com/ss/excel/tips/tip39.htm

Hope that helps,

Smitty