splash screen
 

Found this code:

Private Sub UserForm_Activate()

Application.OnTime Now + TimeValue("00:00:03"), "CloseForm"

End Sub

which displays a splash screen upon opening a workbook.

If there are multiple forms in the workbook how does the above code specify
which form to use as the splash screen?

Dave
--
A hint to posters: Specific, detailed questions are more likely to be
answered than questions that provide no detail about your problem.

splash screen
 

This part tells which one to open...

Private Sub UserForm_Activate()

this calls the UserForm named "UserForm"

splash screen
 

Hmmm....I suppose that should have been obvious.

Thanks.

Dave
--
A hint to posters: Specific, detailed questions are more likely to be
answered than questions that provide no detail about your problem.


"Wood Grafing" wrote:


This part tells which one to open...

Private Sub UserForm_Activate()

this calls the UserForm named "UserForm"