Static Date & Time stamp on Save

[2Took]

Trying to get VBA to put a static value upon workbook being saved, e.g.: "Latest saved: Wed, 09.28.22 - 09:16"

Planning to call below macro on Workbook Before Save. Getting this error for code below:

Sub LatestSaved()

Dim LS As String
Set LS = "Latest updated:   " & Text(Now(), "ddd, mm.dd.yy - hh:mm")

Sheet2.Range("B4").Value = LS

End Sub

 

[Fluff]

You need to change Text to Format.
Text is an Excel function.

 

[2Took]

You need to change Text to Format.
Text is an Excel function.

Changed, but now it gives this:

 

[Fluff]

Remove the word Set, you only Set objects.