Pong Excel Game - Timing issue

I have the attached excel games file. Please ignore the Tic-Tac-Toe and Hangman sheets.

I am trying to make a pong game in Excel, as kind of a mental excercise. I think I have this more or less working, except for a timing issue.

I have the following bit of code:

Please Login or Register  to view this content.

This part in particular is giving me trouble

Please Login or Register  to view this content.

When I set my BallMoveTime to 0.000005, the system is busy the whole time and I cannot move the player bar with the arrow key. When I set it to 0.000006, I can move the bar just fine, but the ball moves very sluggishly. So, I began to add digits to the BallMoveTime to see if there was a happy medium between being unable to move and the ball being too slow.

There is not, seemingly. It seems like when I move the BallMoveTime past some mysterious increment, it changes to either too fast or too slow. There is no gradual shift.

Can anyone help me either make the code more efficient, or adjust the timing so that the game runs smoothly?

Thanks.

Check out Andrew Engwirda's Rocket game for clues on how to handle keyboard input and screen updating.

http://blog.livedoor.jp/andrewe/arch...at_107032.html

I think the problem with you OnTime is a rounding issue. The method is not designed to take such small values.

Ok. Solved. Thank you so much for that link. Looks like quite a playground, both as a programmer and a gamer.

Attached is the fixed version of the game. I plan on adding levels of difficulty and the like, but the foundation is there.

For Excel related games have a look at
http://www.dzikosoft.com/