Timed Userforms

[Drmwvr7266]

Hi Y'all. Great website. Very informative. Quick question: How do I get a userform to appear at startup of a particular worksheet, and then shut itself off? (Using it simply as an introduction) Also, is there a way to eliminate the top banner of the userform, thus eliminating the X in the right corner, and/or replacing it with min/ max buttons instead?
Been searching and haven't found the answer here yet. Thanx in advance for the help!

 

[Mark O'Brien]

On the userform Initialze event, stick in an Application.Wait command then put "Unload Me" after it.

Min and Max:

http://www.mrexcel.com/board/viewtopic.php?topic=1005&forum=2

Disable Close Button is on this board (it is possible to remove is as well), but I need to get outta here, so I can't find it just now.


HTH

 

[Legacy 98055]

Hi
For your first question...

Private Sub UserForm_Activate()
Dim Start
Start = Timer + 2
Do While Timer< Start
DoEvents
Loop
Unload Me
End Sub

Will display the form for 2 seconds and will then unload the userform...

Tom

Didn't mean to over post you Mark...
This message was edited by TsTom on 2002-04-25 13:19

 

[Drmwvr7266]

Thanx for the help. I managed to make something up on the timed event. But I am going to try yours, Tom.
As for the min/max, that may be a bit much for me to digest just yet. Thanx all.