Userform Timer to run on loop

[Gmao]

Hello,

I have a timer in a userform which counts up and displays the count in a text box. However what I would like to do is to have the timer loop and begin again from zero once it reaches a preset limit, say for ease 10 seconds. So the timer would count to 10 then start again at zero and continuously repeat.

The code I have so far is:

Please Login or Register  to view this content.

I've tried editing the btnStart sub however I cant seem to to get it to repeat. Can anyone help?

[cytop]

You need to declare boolStopPressed scoped to the module or whatever this code is in.
You should also use

Please Login or Register  to view this content.

at the top of the module to require all variables be declared before use (If you do, this will cause compiler errors when you try to run the code, until all are declared).

The problem is boolStopPressed is never explicitly declared so when you use it in btnStart_Click it is created but only local to that procedure. The same in btnStop_Click, that copy of the variable is local to the procedure btnStop_Click so they can never 'interact'.

Please Login or Register  to view this content.

I've no idea what dteStopped or dteElapsed are supposed to do, but the same applies. If they are referenced in separate procedures then they must be in scope for those procedures, not local to them.

[Gmao]

Apologies I have not pasted the option explicit part of my code. I don't have access to the document at the minute but shall include it when I can.

However this doesn't help me with making the timer loop. Using the code above along with the option explicit the timer itself works great I just can't get it to loop.

[Gmao]

I have pasted all the code from my userform below and included the file at the bottom. If anyone has any ideas how I can make the timer loop I would be much appreciated.

Please Login or Register  to view this content.