How do I use VBA timer subroutines to start and stop random number generator?

As you can see below, I've written code that writes random numbers into three columns of a spreadsheet (10 numbers in each column).

What I want to do is create code that will run the random number generator for a period of 1 minute and then stop. I know that I will need to write a timer subroutine to do this but I'm how unsure how to do this. Can you help?

Please Login or Register  to view this content.

* the subroutine Workbook_SheetBeforeDoubleClick is meant to allow the user to interrupt the random number generator with a double mouse click and/or a right mouse click or some other event.

Please read the Forum Rules, and then edit your post to wrap your code with Code Tags, and edit your thread title to be descriptive of your problem.

Then we can help you with OnTime method.

The title is a little verbose, but definitely better, thank you.

Search the forum for ontime to find many examples. There is also a good example in VBE Help for the OnTime method. Post back if you get stuck.

You want to run for a minute or until the sheet is double-clicked?

You only need to do Randomize once, not each time before a number is generated ...

Mayb like this.

ThisWorkbook:

Please Login or Register  to view this content.

Code module:

Please Login or Register  to view this content.

I set it to run for 10 seconds (you change can the constant), and it does stop when I double-click.

Do you have events enabled?