Clearing bets

[Drunkenight]

Hi,

I was wondering if anyone can help. I currently clear the bets column to be able to place another bet. The macro I use is:-
Application.OnTime Now + TimeValue("00:00:10")

However I would like to vary the time value. Instead of every 10 seconds, I would like to be able to specify a time from excel. is this possible? For example I would like to put something like:-
Application.OnTime Now + TimeValue=A30
Where A30 = is a variable which specifies the time before I place another bet.
Hope this makes sense.

[Captain Sensible]

If the cell is in the time format i.e 00:00:10 I'd imagine you'd just use something like

Application.OnTime Now + [A30].Value