REPEAT SOME ACTION IN MACRO

[SURESH]

Hi dear friends,

its an simple question for you....
i want to repeat some action in my excel workbook at every 5 minuts.. by the
help of VB

just like

Private Sub Workbook_Open()
Application.ScreenUpdating = false
dim ST, NT as date
ST = timer
nt = st + TimeValue("00:05:00")
loop
if nt = timer then
call XXX
end if
do events
end loop
End Sub

can anyone help me??

thanks in advance

suresh tp

[Rich_z]

Please Login or Register  to view this content.

Regards

Rich

[Dave Peterson]

If you want to read more about Excel's VBA OnTime method, visit Chip Pearson's
site:
http://www.cpearson.com/excel/ontime.htm

SURESH wrote:
>
> Hi dear friends,
>
> its an simple question for you....
> i want to repeat some action in my excel workbook at every 5 minuts.. by the
> help of VB
>
> just like
>
> Private Sub Workbook_Open()
> Application.ScreenUpdating = false
> dim ST, NT as date
> ST = timer
> nt = st + TimeValue("00:05:00")
> loop
> if nt = timer then
> call XXX
> end if
> do events
> end loop
> End Sub
>
> can anyone help me??
>
> thanks in advance
>
> suresh tp

--

Dave Peterson