Timed Userforms

Drmwvr7266 · Apr 25th, 2002, 02:01 PM

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 · Apr 25th, 2002, 02:14 PM

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/viewtop...c=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

Tom Schreiner · Apr 25th, 2002, 02:17 PM

Hi
For your first question...

Quote:

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 · Apr 25th, 2002, 02:24 PM

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.

Apr 25th, 2002, 02:14 PM	#2
Mark O'Brien MrExcel MVP Join Date: Feb 2002 Location: Columbus, OH, USA Posts: 3,519	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/viewtop...c=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 __________________ Mark O'Brien Columbus Ohio Celtic Supporters Club

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Apr 25th, 2002, 02:01 PM	#1
Drmwvr7266 Board Regular Join Date: Apr 2002 Location: Nashua NH Posts: 164	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!

Apr 25th, 2002, 02:24 PM	#4
Drmwvr7266 Board Regular Join Date: Apr 2002 Location: Nashua NH Posts: 164	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.