I'm trying to write a simple VBA for a Lucky draw for a charity event here. Unfortunately I've misjudged my VBA knowledge a bit, I'm rusty...

My aim:
Have one cell quickly display a random number within a predefined range of numbers and stop this with a stop button.

Sofar I have this code:

Sub startTimer()
Application.OnTime Now + TimeValue("00:00:01"), "Increment_count"
End Sub

Sub Increment_count()
Range("A3").Value = Range("A3") + 1
startTimer
End Sub

Sub StopTimer()
Application.OnTime Now + TimeValue("00:00:01"), "Increment_count", Schedule:=False
End Sub

The problem now is:
1. I need to limit the range as specified in 2 cells (from and to range). (now it just runs up indefinitely)
It should keep running till I click the stop button.
2. I would prefer the numbers to be displayed randomly
3. The change in numbers is far too slow (1 per second)

Any help will be greatly appreciated,
Tnx

Jan