Auto closing UserForm

's Computer Specifications

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

's Computer Specifications

See http://www.ozgrid.com/Excel/excel-splash-screen.htm

--
Regards
Dave Hawley
www.ozgrid.com
"ordnance1" <(E-Mail Removed)> wrote in message
news:AE30FA14-CF76-4375-BCDE-(E-Mail Removed)...
> 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
>

's Computer Specifications

Thanks for the point

"ozgrid.com" wrote:

> See http://www.ozgrid.com/Excel/excel-splash-screen.htm
>
>
>
> --
> Regards
> Dave Hawley
> www.ozgrid.com
> "ordnance1" <(E-Mail Removed)> wrote in message
> news:AE30FA14-CF76-4375-BCDE-(E-Mail Removed)...
> > 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
> >
>

's Computer Specifications

See reply at your other post.

Gord Dibben MS Excel MVP

On Mon, 26 Apr 2010 21:38:01 -0700, ordnance1
<(E-Mail Removed)> wrote:

>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

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Closing Userform	=?Utf-8?B?RGF2ZSBN?=	Microsoft Excel Programming	1	15th Aug 2007 02:55 PM
Prevent closing userform	Gert-Jan	Microsoft Excel Programming	0	8th Oct 2006 03:48 PM
Closing UserForm	=?Utf-8?B?S2VyaQ==?=	Microsoft Excel Programming	3	25th Oct 2005 07:31 PM
closing a userform	mangesh_yadav	Microsoft Excel Programming	5	31st Aug 2004 02:26 PM
Re: Help with closing a UserForm	Ron de Bruin	Microsoft Excel Programming	0	8th Aug 2003 01:52 PM