splash screen

[Dave F]

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

 

[Wood Grafing]

This part tells which one to open...

Private Sub UserForm_Activate()

this calls the UserForm named "UserForm"

 

[Dave F]

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

Thanks.

Dave