Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 1
Default 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


  #2   Report Post  
Posted to microsoft.public.excel.programming
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

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Name conflict smaruzzi Excel Discussion (Misc queries) 3 October 4th 08 01:44 PM
Name Conflict Roger[_4_] Excel Discussion (Misc queries) 2 March 15th 08 01:13 AM
Name Conflict Roger[_4_] Excel Discussion (Misc queries) 5 March 14th 08 02:14 PM
Quicktime Conflict lawrence Excel Discussion (Misc queries) 0 July 2nd 07 02:44 AM
Stopping a Timer / Running a timer simultaneously on Excel Paul23 Excel Discussion (Misc queries) 1 March 10th 06 12:08 PM


All times are GMT +1. The time now is 12:52 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"