Vba expert needed please

[Scorpion Steve]

Hi, This is in relation to my latest thread!
is there a way of having the follwing turn into vba code?
when open workbook:
run refresh on this workbook at this time: ####
and again at this time: ####

--or--

refresh workbook every ## mins

--or--

refresh workbook
count down ##mins
refresh workbook
countdown ##mins

?? Thanks!

 

[Scorpion Steve]

ok, I have found this code:

Public Sub do_refresh()
If Sheet1.CommandButton1.Caption = "Stop" Then
refresh
Application.OnTime Now + TimeValue("00:00:10"), "do_refresh"
End If
End Sub

How can I re-write this sub to say, once opened.. start timer, refresh and repeat?

Thanks