Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Hi,
A solution is to input your date/time stamp, whenever needed in the cell 's Comment ... HTH Cheers Carim |
#2
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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 |
#3
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
If you simply want the date and time etc in the activecell
Sub StampNow() ActiveCell.Value = Now() ActiveCell.Copy ActiveCell.PasteSpecial (xlPasteValues) Calculate CutCopyMode = False End Sub 'somethinglikeant |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Time date stamp | Excel Worksheet Functions | |||
Date-time stamp | Excel Discussion (Misc queries) | |||
Trigger a Date & Time stamp by entering data in another field... | Excel Worksheet Functions | |||
Date-Time Stamp | Excel Discussion (Misc queries) | |||
Date/time Stamp? | Excel Programming |