PDA

Click to See Complete Forum and Search --> : Timer and Excel


QWERTY
Dec 9th, 1999, 07:54 AM
I have a problem with my application. Every time I'm doing something in Excel (from my app of course) it disables my Timer (which has a really important funtion). I'm mean it doesn't really disables it, but it doesn't let the timer to do anything. Do you know what's going on?
Thanks

------------------
Visual Basic Programmer
------------------
PolComSoft
You will hear a lot about it.

SteveS
Dec 9th, 1999, 09:58 AM
If the app gets really busy, you may need to add the command,

DoEvents

somewhere inside the loop, without this if the loop takes a long time, then all processing of the code stays within your loop

Hope this helps,

Steve

QWERTY
Dec 9th, 1999, 10:10 AM
Thanks SteveS it helped a lot!!

------------------
Visual Basic Programmer
------------------
PolComSoft
You will hear a lot about it.