I am trying to switch between two routines with a timer. The start works fine however the stoptimer throws a 1004 error. Can anyone point out the obvious (not obvious to me and that's why I am pulling my hair out). Many thanks!
Please Login or Register to view this content.
Last edited by aprildu; 02-22-2016 at 09:19 PM.
Have a look at http://www.cpearson.com/excel/OnTime.aspx
It should have all the information you need & doing it yourself is the best way to learn
Cheers
Thanks philb1. I did google but somehow the above codes just won't work. I was hoping someone could point out what the problem is.
I haven't done this in a while so had to work it out as well. I added a bit to show the rows if they were hidden when you pressed the stop button.
Sorry I changed it around a bit to how my brain works(Back to front normally)
Try the code below
Sorry I can't post the workbook as the site won't let me. I put start & stop buttons on sheet 1, the Start button macro is StartTimer, Stop button is StopTimer
Please Login or Register to view this content.
Thank you! It worked. The difference is the conditions? I guess the errors must be caused by those? Error 1004 usually is caused by name, range...
Last edited by aprildu; 02-23-2016 at 01:58 PM.
Good job Philb1.
The difference is the 'On Error resume Next' which is needed to suppress the Runtime error that occurs when the timer is not scheduled (either not scheduled or when RotateRows() is executing).
It is also good programming practice to put StopTImer() in the Workbook_BeforeClose() routine in the ThisWorkbook code module. If this is not done, the spreadsheet may unexpectedly 'rise from the dead'.
Lewis
Last edited by LJMetzger; 02-23-2016 at 03:28 PM.
Glad it worked out.
Thanks for the compliment Lewis & thank you both for the rep
Cheers
Phil
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks