Set Wintimer ID

I'm not sure what you're asking for. The TimerID is just a number which identifies the timer; you can't link it to a cell. Do you mean:
where A1 contains the timer interval in milliseconds?

Hi John.

I have trouble sometimes when I run various things it stops the timer working correctly and it runs at double speed and will not stop running unless I actually close the workbook, which is annoying and also it can cause a lot of problems when not running at the correct speed, I have it linked to a cell to start and end but when it goes wrong it doesn't matter what I type in the cell or even call the endtimer statement, it just keeps running.

Someone told me that you need to set the timer ID so that it doesn't lose focus but I didin't know how to do that.

A TimerID is a number allocated by the operating system. You have to declare it as Public at the top of a standard module so that its value is retained whilst the workbook is open, and so that the value can be passed to the KillTimer function to stop the timer. See http://www.cpearson.com/excel/OnTime.aspx.

Thanks John,

I was hoping that there was a solution to make sure that when the endtimer function is called that it makes sure to kill the timer, so that when it loses focus it doesn't keep running or run at double speed etc...

It doesn't haapen all the time, but usually once of twice a day it goes berserk and I have to close my workbook and then reopen it to stop the timer.

Often it happens because I forget to stop the timer when I go in to modify forms or modules in my workbook and that stops it running properly.