LinkBack URL
About LinkBacks
I need to pause for 0.5 seconds (half a second)
How can I do that.
Applicatiom.Wait can only be used for whole seconds and a FOR ... NEXT loop is CPU dependant. Any good ideas?
Gr,
Ricardo
I need to pause for 0.5 seconds (half a second)
How can I do that.
Applicatiom.Wait can only be used for whole seconds and a FOR ... NEXT loop is CPU dependant. Any good ideas?
Gr,
Ricardo
Last edited by rwgrietveld; 06-04-2009 at 02:54 AM. Reason: solved
Looking for great solutions but hate waiting?
Seach this Forum through Google
www.Google.com (e.g. +multiple +IF site:excelforum.com/excel-general/ )
www.Google.com (e.g. +fill +combobox site:excelforum.com/excel-programming/ )
Ave,
Ricardo
This is an example of one way to do it with milliseconds. This creates a definable variable "sleep" and 500 equals half of a second.
Just to give an idea...
Please Login or Register to view this content.
_________________
Microsoft MVP 2010 - Excel
Visit: Jerry Beaucaire's Excel Files & Macros
If you've been given good help, use theicon below to give reputation feedback, it is appreciated.
Always put your code between code tags. [CODE] your code here [/CODE]
?None of us is as good as all of us? - Ray Kroc
?Actually, I *am* a rocket scientist.? - JB (little ones count!)
Use the windows API Sleep function
Declare this at top of module
Please Login or Register to view this content.Please Login or Register to view this content.
Please Read Forum Rules Before Posting
Wrap VBA code by selecting the code and clicking the # icon or Read This
How To Cross Post politely
Top Excel links for beginners to Experts
If you are pleased with a member's answer then use the Scales icon to rate it
If my reply has assistedor failed to assist you
I welcome your Feedback.
Thanks both of you. It works. Now I have an additional question and I'll open another thread.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks