How to finish a userform on a timed basis

Wil Moosa

Well-known Member
Joined
Aug 11, 2002
Messages
882
I have the following code for an opening screen (userform). I want this to disappear after 2 seconds. How can this be done?

The code:

Sub Show_introductiescherm()
Introductiescherm.Show

End Sub
 

Some videos you may like

Excel Facts

Easy bullets in Excel
If you have a numeric keypad, press Alt+7 on numeric keypad to type a bullet in Excel.

Richie(UK)

MrExcel MVP
Joined
May 17, 2002
Messages
3,329
Hi Wil,

Try something like this:

<pre>Private Sub UserForm_Activate()
Application.Wait (Now + TimeValue("0:00:02"))
Unload Me
End Sub</pre>
HTH
 

Wil Moosa

Well-known Member
Joined
Aug 11, 2002
Messages
882
Returns the error message: "invalid use of the keyword Me".
This message was edited by Wil Moosa on 2002-11-09 07:54
 

dk

MrExcel MVP
Joined
Feb 15, 2002
Messages
2,942
You need to make sure that Richie's code is in the code module of the userform, not a normal module. Just double click your form and paste in Richie's code.
 

Watch MrExcel Video

Forum statistics

Threads
1,122,658
Messages
5,597,403
Members
414,142
Latest member
Banyangt

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top