ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   timer conflict (https://www.excelbanter.com/excel-programming/273763-timer-conflict.html)

SJ[_4_]

timer conflict
 
Hi,
I have a timer funciton that calls some routines every minute. The problem
is that if I am using a userform the timer process interupts and causes the
form to fail.
Any ideas on how to remedy this?

Thanks,
Steve



BrianB

timer conflict
 
I would set up a variable and change it when the form is in use, then
change it back when the form is closed. Your timer routine can then
check this variable before trying to do anything.



Regards
BrianB
===================================

"SJ" wrote in message ...
Hi,
I have a timer funciton that calls some routines every minute. The problem
is that if I am using a userform the timer process interupts and causes the
form to fail.
Any ideas on how to remedy this?

Thanks,
Steve



All times are GMT +1. The time now is 07:05 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com