LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 3,885
Default Date time stamp

Hi
you may put the following code in your workbook module

Private Sub Workbook_Open()
Worksheets("Sheet1").Select
Range("A1").Value = now
End Sub


--
Regards
Frank Kabel
Frankfurt, Germany

Erik wrote:
I am trying to place a date/time stamp in one cell that is updated
when the sheet is opened. What is the best way to do this? Erik

 
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
Date-Time Stamp [email protected] Excel Discussion (Misc queries) 1 September 27th 06 02:37 PM
date/time stamp Jan Excel Worksheet Functions 7 July 14th 05 01:04 PM
Date time stamp Chip Pearson Excel Programming 0 March 1st 04 04:14 PM


All times are GMT +1. The time now is 12:16 PM.

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"