LinkBack URL
About LinkBacks
Dear experts;
I want to repeat a macro every 5 minute, but my code doesn't seem to work correctly.kindly give your idea.
Please Login or Register to view this content.
Dear experts;
I want to repeat a macro every 5 minute, but my code doesn't seem to work correctly.kindly give your idea.
Please Login or Register to view this content.
Last edited by shaukat; 11-26-2011 at 02:11 AM.
Hi,
Please Login or Register to view this content.
Richard Buttrey
RIP - d. 06/10/2022
If any of the responses have helped then please consider rating them by clicking the small star iconbelow the post.
hi Rchard,Originally Posted by Richard Buttrey
thanks for your prompt response, I tried it for 1 minute cycle.It ran for 1st sycle, 2nd cycle did not.moreover it only works when hit F5. the moment i hit F5 it will run rgiht after 1 minute. Not the minute hand of windows clock .Any Idea please?
thanks
Since you must be able to stop this macro you need something more
Please Login or Register to view this content.Please Login or Register to view this content.
perhaps this example will help you
Hello SNB,Since you must be able to stop this macro you need something more
Please Login or Register to view this content.Please Login or Register to view this content.
thanks for your valuable input, some how the output of your macro is only one cycle.means runs only once. I have tried this in module1
Please Login or Register to view this content.
Hello Nilem,
thanks for sharing .I still am trying to catch up this code, what is the meaning of this line.
Application.OnTime NextTick, "UpdateClock"
what i mean is why did you use "UpdateClock" inside the Sub UpdateClock()
Last edited by shaukat; 11-25-2011 at 01:54 PM.
Pleas do not quote (see the forum rules)
You shouldn't have changed anything in the code I provided.
Put my code in a macromocule and start the macro Macro_new. That's all.
You might add a messagebox to macro Macro_new.
But please read the VBEditor's helpfiles on 'ontime' to analyse & understand the code.
thanks, I will not Qoute again.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks