Timer not working in VBA - Urgent help please

**cross0404** · 04-13-2013, 06:29 PM

Hi,

I urgently need help with a problem I have. I have a button on an excel worksheet that opens a userform, reads an excel file row by row until the last row of data and based on the values in the cells will display an image. This is to create an animation effect. The program is working fine, however the problem I have is that I have tried to put a timer in to slow down the animation but it is just not working and I don't know why. When I run the animation it goes so fast through each row there is no time to see the images. The only way I can ensure that it is working is if I put breakpoints at each case which shows me it is actually working.

I would also like to stop the "loop" when it gets to the last row instead of just going through all the rows and then starting again. The code for the program is below:

Please Login or Register  to view this content.

**AndyLitch** · 04-14-2013, 05:46 AM

An API timer should make the programming much simpler

At the top of a code module

Please Login or Register  to view this content.

And in your subroutine

Please Login or Register  to view this content.

**cross0404** · 04-14-2013, 04:07 PM

Hi AndyLitch,

Thanks for your assistance. Smallman on Ozgrid kindly helped me with the very same solution last night. Please click on the link http://www.ozgrid.com/forum/showthread.php?t=177511 to see the full code working. I had some Office 2013 64 bit issues and I also managed to sort out the code to exit the loop after a certain number of rows.

**jaslake** · 04-14-2013, 05:14 PM

Hi cross0404

Please read this Forum Rule

8. Don't cross-post without a link. Cross-posting is when you post the same question in other forums on the web. You'll find people are disinclined to respond to cross-posts because they may be wasting their time solving a problem that has been solved elsewhere. We prefer that you not cross-post at all, but if you do (and it's unlikely to go unnoticed), you MUST provide a link (copy the URL from the address bar in your browser) to the cross-post. Expect cross-posts without a link to be closed.

I'd suggest AndyLitch wasted his/her time...I know that aggravates me when I do the same.