Hi dragon,
I am encountering the same error "Run-time error '1004' Method 'onTime of object'_Application' failed", how did you solved it?
Printable View
Hi dragon,
I am encountering the same error "Run-time error '1004' Method 'onTime of object'_Application' failed", how did you solved it?
Hello raymondlee
This is really xld's work that I was messing around with - don't understand the topic that well and it's been sometime since I really thought about it...but did you see the code in Excel file attached to post 20? That's the final version.
Basically, in the CMD1_click sub and the Userform_Query Close event you need to stop the ShowCountdownClock timer before restarting the inactivity Countdown timer. If you don't stop the ShowCountdownClock timer then VBA treats it as if you've done a control-break out of the procedure (at least thats how it seems to me - but don't ask me why!)