UPDATING NOW() AUTOMATICALLY

[bensonjr]

UPDATING NOW() AUTOMATICALLY


I have the =NOW() formula in several worksheets. How can I have them automatically updated, let’s say every 5 seconds? Thank you very much for your help . . .

[mdmackillop]

Sub Update()
Application.OnTime Now + TimeValue("00:00:05"), "MyMacro"
End Sub

Sub MyMacro()
Calculate
Update
End Sub