VBA to automatically update the current date.

VBA to automatically update the current date.

Hello,

I'm looking to have a VBA to keep the date of the day automatically updated without having to refresh or openmy Zoho sheet.

I've tried this but it doen't work, can you please help?

Here is what I tried:

Sub date_update()
Range("H1") = Date 
Application.Calculate

dim prochainLancement as Double
prochainLancement = now() + TimeSerial (0, 0, 1)
Application.OnTime prochainLancement, "date_update"
End Sub

Many thanks for your help and kind regards,

Géraldine