View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.programming
Carim[_3_] Carim[_3_] is offline
external usenet poster
 
Posts: 137
Default automatically add date/time stamp to field?

Hi,

Found an old "stamp" ....

Sub MacroStamp()
Dim Stamp As String
Dim Str As String
Str = Format(Time, "hh:mm:ss AMPM")
Stamp = Format(Date, "Long Date") & " at " & Str
Selection.AddComment
Selection.Comment.Text Text:=Stamp
Selection.Select
End Sub

HTH
Cheers
Carim