Creating a time delay in VBA before form unloading.

datastream · May 14th, 2002, 06:57 PM

How would you creat a slight few second delay, say 1 second, before the code to unload a userform?
(basically stayin on the same userform without having to switch between two identical forms, each unloading the other after input)
Thanks for any help.

Tom Schreiner · May 14th, 2002, 07:30 PM

Try this line where appropriate:
Application.Wait Now + #12:00:01#
Or
Application.Wait Now + TimeValue(0,0,1)
Tom

Mark O'Brien · May 14th, 2002, 07:33 PM

Something like this:



Application.Wait Now + TimeValue("0:00:01")

'...code for whatever it is you want to do

HTH

NateO · May 14th, 2002, 07:36 PM

If you want to state the delay in ()'s you'll need the serial:



Application.Wait Now + TimeSerial(0, 0, 1)

Or by a standard time value:



Application.Wait Now + TimeValue("00:00:01")

Hope this helps.

NateO · May 14th, 2002, 07:37 PM

I thought you would've been on the 19th hole Mr. O'Brien!

Didn't mean to restate your post. Have a good one y'all.

_________________
Cheers, NateO

[ This Message was edited by: nateo on 2002-05-14 18:46 ]

Fajitas · Jul 7th, 2010, 06:19 PM

Quote:

Originally Posted by Tom Schreiner

Try this line where appropriate:
Application.Wait Now + #12:00:01#
Or
Application.Wait Now + TimeValue(0,0,1)
Tom

Can´t find member method... -says Office 2003-
I may be missing some library reference.

Anything better than 'Wait' ?

May 14th, 2002, 07:33 PM	#3
Mark O'Brien MrExcel MVP Join Date: Feb 2002 Location: Columbus, OH, USA Posts: 3,519	Something like this: Application.Wait Now + TimeValue("0:00:01") '...code for whatever it is you want to do HTH __________________ Mark O'Brien Columbus Ohio Celtic Supporters Club

May 14th, 2002, 07:36 PM	#4
NateO Legend Join Date: Feb 2002 Location: Minneapolis, Mn, USA Posts: 9,704	If you want to state the delay in ()'s you'll need the serial: Application.Wait Now + TimeSerial(0, 0, 1) Or by a standard time value: Application.Wait Now + TimeValue("00:00:01") Hope this helps. __________________ Regards, Nate Oliver Microsoft Excel MVP Nate's Excel Blog

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

May 14th, 2002, 06:57 PM	#1
datastream New Member Join Date: Apr 2002 Location: Kansas City, MO Posts: 14	How would you creat a slight few second delay, say 1 second, before the code to unload a userform? (basically stayin on the same userform without having to switch between two identical forms, each unloading the other after input) Thanks for any help.

May 14th, 2002, 07:30 PM	#2
Tom Schreiner Board Regular Join Date: Mar 2002 Location: Cincinnati, Ohio, USA Posts: 6,824	Try this line where appropriate: Application.Wait Now + #12:00:01# Or Application.Wait Now + TimeValue(0,0,1) Tom

May 14th, 2002, 07:37 PM	#5
NateO Legend Join Date: Feb 2002 Location: Minneapolis, Mn, USA Posts: 9,704	I thought you would've been on the 19th hole Mr. O'Brien! Didn't mean to restate your post. Have a good one y'all. _________________ Cheers, NateO [ This Message was edited by: nateo on 2002-05-14 18:46 ]