API Timer Problem

  • Thread starter Thread starter Seth
  • Start date Start date
S

Seth

I am using the API timer functions in an Excel XP
project. I use the timer to refresh information every 1
second on a userform. When the user form initializes I
start the timer, and on terminate I stop the timer.

The problem is that when I return to Excel I am not able
to use the mouse to click on cells or toolbar buttons. I
found that hitting ctrl-O to open the File Open dialog
will "wake" Excel up (I can select cells and click
toolbar buttons again once I close this dialog).

Does anybody know what is going on? I only get this
problem when I use the API timer functions in conjunction
with a UserForm.

Thanks,

Seth
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

API Timer 1
API Timer Function Issue 1
Count Timer Pause and Stop button 1
Stop my timer 4
API Timer 2
need a Timer in an Excel Form 3
Setting timer to run macro at regular intervals 3
making a countdown timer 1

Back
Top