LinkBack URL
About LinkBacks
1.How can we trigger a Macro called Mega to run at time intervals of 3 seconds continuously and, 2. What can we do to stop it at will ( i.e. any time we want to stop it) ?
1.How can we trigger a Macro called Mega to run at time intervals of 3 seconds continuously and, 2. What can we do to stop it at will ( i.e. any time we want to stop it) ?
Run the macro Mega_Start to start the timed interval of Mega and run Mega_Stop to stop it.
Please Login or Register to view this content.
Surround your VBA code with CODE tags e.g.;
[CODE]your VBA code here[/CODE]
The # button in the forum editor will apply CODE tags around your selected text.
Thanks for taking out time to help me out. Unfortunately I don't understand the VBA system and am only too ignorant to understand your sophisticated code. Can you please correct the file attached and upload so that the working of the code may really become automated once the start button is pressed ( only to be stopped by the stop button !). At present it only works if the start button is pressed.
Thanks again
"Bump no response"
At present , the macro does not work automatically ( which was the basic idea). Can anyone help using the file Timer macro Mega attached above ? The timer should act on its own once triggered by the button. Thanks !
"Bump no response"
Timed Macro Mega try.xlsm
Try that out... it wont let you call out of a sheet the way you had it setup..
Wow its great, JUST Perfect .....Thanks a lot for your time, effort and help ! God bless !
The problem is solved.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks