A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Excel » Worksheet Functions
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Set the time and date for editing a cell



 
 
Thread Tools Display Modes
  #1  
Old January 6th, 2007, 01:31 PM posted to microsoft.public.excel.worksheet.functions
vh
external usenet poster
 
Posts: 3
Default Set the time and date for editing a cell

I want to be able to set the time and date when editing a cell automatically.
For example I have a list that I have to update periodically and instead of
typing in when I updated the cell, I want to involve another cell that tells
when the cell was last edited and updated with text or numbers.
Is this possible without using VB?
--
Best Regards VH
  #2  
Old January 6th, 2007, 02:10 PM posted to microsoft.public.excel.worksheet.functions
Max
external usenet poster
 
Posts: 8,574
Default Set the time and date for editing a cell

Is this possible without using VB?

Don't think so ...

Try JE McGimpsey's coverage of "Time and date stamps" at his page:
http://www.mcgimpsey.com/excel/timestamp.html

Here's a sample file from my archives
(with JE's sub implemented):
http://savefile.com/files/41920
Date_Time_Stamping.xls
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"VH" wrote in message
...
I want to be able to set the time and date when editing a cell
automatically.
For example I have a list that I have to update periodically and instead
of
typing in when I updated the cell, I want to involve another cell that
tells
when the cell was last edited and updated with text or numbers.
Is this possible without using VB?
--
Best Regards VH



  #3  
Old January 6th, 2007, 05:05 PM posted to microsoft.public.excel.worksheet.functions
CLR
external usenet poster
 
Posts: 323
Default Set the time and date for editing a cell

Not to my knowledge.........

Could be done relatively easy with VBA tho......just need to identify which
cells would be involved......and the feature could even be toggled off and
on if you wish.........

Vaya con Dios,
Chuck, CABGx3



"VH" wrote in message
...
I want to be able to set the time and date when editing a cell

automatically.
For example I have a list that I have to update periodically and instead

of
typing in when I updated the cell, I want to involve another cell that

tells
when the cell was last edited and updated with text or numbers.
Is this possible without using VB?
--
Best Regards VH



 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 03:24 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.