Hi
I have a timer that runs to send a mail based on criteria. Problem is....the timer does not stop.....ever.....mailbox flooded, please help urgently.
the code above is what I used....I need something in before close to stop the timer 'cause it does not stop when I close the workbook.
Please Login or Register to view this content.
the end result I'm looking for is for the timer to run every 2 minutes and check for the criteria as per the below but, I am not 100% sure the below code is right?
Please Login or Register to view this content.Please Login or Register to view this content.
I don't know what criteria you want but the submited code works like this:
For each value in range:
if value = 3 call Mail43 AND then call Timer1
if value <> 3 call Timer1
.. and don't forget to have fun!
Bogdan.
mark SOLVED andAdd Reputation if my answer pleases you
thank you for the reply, but I need the code to stop the timer running.....when I close the workbook......the timer just keeps on running, so I need to put something in the "before workbook close" event to stop the code from running when I close the workbook.
get the Call Timer1 out of the For Nex loop:
The timer should stop if you close the file. But maybe you should implement a method/condition to stop the timer.Please Login or Register to view this content.
tried another approachmuch like you are suggesting.
thank you very much for the assistance bulina2kn
Did you try this?
PHP Code:Private Sub Workbook_BeforeClose(Cancel As Boolean)
Application.OnTime Now + TimeValue("00:02:00"), "Check1", , False
End Sub
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks