Thread: timer conflict
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
BrianB BrianB is offline
external usenet poster
 
Posts: 109
Default 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