Hello all,
I'm trying to run macro every x seconds when the Toggle Button is pressed in. When it's unpressed the macro should stop running. But unfortunately when you unpres the button the macro keeps running. This is what i have come up with so far:
Button code:
Macro:
Please Login or Register to view this content.
Please Login or Register to view this content.
To do it for me and help me it is 2 different things!
Sorry for my english, blame Google translator
Apologies but this does not solve the problem. I'm aiming to cancel a scheduled on time event.
Hello ChipsSlave,
You need to check the state of the Toggle Button before you call startSaveTimer.
Here is the amended code. Change the name of the worksheet your Toggle Button is on if it is not Sheet1.
Please Login or Register to view this content.
Sincerely,
Leith Ross
Remember To Do the Following....
1. Use code tags. Place [CODE] before the first line of code and [/CODE] after the last line of code.2. Thank those who have helped you by clicking the Starbelow the post.
3. Please mark your post [SOLVED] if it has been answered satisfactorily.
Old Scottish Proverb...
Luathaid gu deanamh maille! (Rushing causes delays!)
What if the button is placed in a user form called "menu"? I have tried to replace "Worksheets("Sheet1").OLEObjects("To..." into "menu.OLEObjects("To..." but it doesnt work. Any ideas?
Never mind sorted. Thank you.
Please Login or Register to view this content.
Hello ChipsSlave,
Glad you got that sorted out. It is more rewarding when you can figure it out on your own.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks