VBA - to update a cell when a query is ran.

[itsgrady]

Is there a vba code I can use to update a cell each time I run a query with the date and time automatically. I don’t need the date and time to update when I open the excel file though, just when I run a query.

G4 - date and time cell
Worksheet - “VPI-All-WhsRpt”

Thanks.

 

[rpaulson]

Worksheets("VPI-All-WhsRpt").[G4] = Now

 

[itsgrady]

Worksheets("VPI-All-WhsRpt").[G4] = Now

Thanks for the reply. Will date and time update automatically only after refreshing a query?