refresh a cell automaticaly each second ?

[LoloSoft]

hello,

how to refresh a cell automatically each second (by example)
in VBA /excel ?

thanks

 

[chandlm]

Laurent,

This should do what you want.

you will need to add this to the workbook open event

Private Sub Workbook_Open()
Call updatecell
End Sub

and add this to a code module

Sub updatecell()
Range("a1").Value = Range("a1").Value + 1 ' amend this to do wha
updates you need.

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


HTH
;

 

[LoloSoft]

thanks