L LoloSoft Jan 20, 2004 #1 hello, how to refresh a cell automatically each second (by example) in VBA /excel ? thanks
C chandlm Jan 20, 2004 #2 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 ;
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 ;
