Auto closing UserForm

O

ordnance1

Hi

JLGWhiz had been helping me with this, but I took a few days off before I
got back to this. The code below is what he suggested, but while the UserForm
triggers, it does not disappear after 5 seconds (or any length of time). Any
suggestions out there?


Sub test()

UserForm1.Show
Application.Wait (Now + TimeValue("00:00:05"))
Unload UserForm1

End Sub
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

If no activity, display a UserForm; 10 seconds later close Workboo 4
Splash Screen Behavior 2
display userform for 10 seconds 7
Printing userform in landscape on one page only 2
Errors Closing Userform 0
Resizing and Printing a UserForm 3
Unloading userforms 6
Is there an easy Copy/Paste of a Userform ? (Entire Userform Including tx & cbx's) 1

Top