Splash Screen In Excel XP Still Looking
Hello all,
I have a continuing problem with a splash screen. i have
included the code below. the form works but i cannot get
it to open upon startup of the workbook. VB is new to me
i have purchased a book to learn unfortunately it's been
quite useless!
This bit of code is in my UserForm:
Private Sub UserForm_Activate()
Application.OnTime Now + TimeValue("00:00:02"),
("KillTheForm")
End Sub
And then in Module1 I have this:
Private Sub Workbook_Open()
UserForm.Show
End Sub
Private Sub KillTheForm()
Unload UserForm
End Sub
I got this piece of code from
www.j-walk.com/ss/excel/tips/tip39.htm
The screen will display for two seconds when i run the
code but it will not run upon startup of the workbook?!
Can anyone please help me figure out what i'm
doing wrong? Should i have the Open command in the form
or in the module? I've tried both and i get the same
answer it'll display but not on startup.
Thanks,
Kevin M
