Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 137
Default automatically add date/time stamp to field?

Hi,

A solution is to input your date/time stamp, whenever needed in the
cell 's Comment ...

HTH
Cheers
Carim

  #2   Report Post  
Posted to microsoft.public.excel.programming
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

  #3   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 94
Default automatically add date/time stamp to field?

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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Time date stamp naslami Excel Worksheet Functions 0 October 6th 09 03:11 AM
Date-time stamp Daniel Excel Discussion (Misc queries) 3 September 7th 09 10:58 AM
Trigger a Date & Time stamp by entering data in another field... mjjohnso Excel Worksheet Functions 4 April 11th 09 06:46 PM
Date-Time Stamp [email protected] Excel Discussion (Misc queries) 1 September 27th 06 02:37 PM
Date/time Stamp? Bowes813[_3_] Excel Programming 7 June 3rd 05 08:10 AM


All times are GMT +1. The time now is 02:08 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"