Time Stamp Issue
Hello,
I am having an issue with my Time Stamp function on my spreadsheet. I have set it up so that in one cell the user can select 'complete', 'not complete' or 'not required' from a drop down list. When the user selects 'complete', the cell next to it will stamp the current date.
The issue is when I close the program and re-open it, the time stamp changes to the current date the document was opened. I want to keep a fixed date in that cell but do not know how to code this.
I have attached a copy of my spreadsheet.
I would appreciate any help you can offer. Thank you.
Kevin
| Attachment | Size |
|---|---|
| Upgrade Procedures & Responsibilities (version 3) JAN 24 2011.xlsx | 47 KB |
Time Stamp Solution
Another solution would be to do the Time stamping thing on the change event in that sheet. Check the target parameter of the change event for its address and text and accordingly change the next cell with the current date/time.
You would be required to save your file in .xlsm format to save any macro.
Hi Kevin, One way to resolve
Hi Kevin,
One way to resolve the issue would be to use Combo Boxes instead of Drop Down Lists, and then to assign macros to the Boxes to do the timestamping.
For an illustration, see attached file at http://www.excelexperts.com/node/1146
Robert