date stamp when cell changed

[richardjshaffer]

Hi,

hope someone can help, very simply I want to capture the date and time that a cell is changed.

So if the value in cell A2 is changed, then cell B2 date stamps with the current time; similiarly if cell A3 is changed, then cell B3 date stamps...

Tried looking at previous threads, I'm a bit confused by one that seems to work with a personal sub? Please can someone help, I'm no expert in macros but if there's a simple one I can use, or a formula based solution, I'd be very grateful,
thanks, Richard

 

[ATSJ]

ATSJ,

Thanks for the feedback.

You are very welcome. Glad I could help.

And, come back anytime.

One more thing. Post #24 highlighted all cells that were updated by changing background color. Is it possible to adapt this so that the background changes color for, say, a day and is then removed beyond that?

 

[hiker95]

One more thing. Post #24 highlighted all cells that were updated by changing background color. Is it possible to adapt this so that the background changes color for, say, a day and is then removed beyond that?

ATSJ,

1. How many times a day do you open/close the workbook?

2. If you open/close the workbook more then once a day, what cell in row 1 can be used to keep track of the date?

3. When you open the workbook, the Workbook_Open event can be utilized to check the above date in the cell in question #2, and, if the date is greater than a date in range D2:D1000, then the background color in range A2:C1000 can be cleared. Is this acceptable?

 

[ATSJ]

ATSJ,

1. How many times a day do you open/close the workbook?

2. If you open/close the workbook more then once a day, what cell in row 1 can be used to keep track of the date?

3. When you open the workbook, the Workbook_Open event can be utilized to check the above date in the cell in question #2, and, if the date is greater than a date in range D2:D1000, then the background color in range A2:C1000 can be cleared. Is this acceptable?

Spreadsheet will be open and closed a bunch of times, more than three I would say. Using any cell outside of the cells in the example, say for example A10, would be fine because presumably that could be hidden out of view anyway? Your idea sounds ideal, I understand there would need to be a mechanism by which it could be checked.

 

[hiker95]

using any cell outside of the cells in the example, say for example a10, would be fine because presumably that could be hidden out of view anyway?

ATSJ,

A10 is in the Range("A2:C1000"), and, can not be used.

What cell in row 1, to the right of cell D1, can I use?

 

[ATSJ]

ATSJ,

A10 is in the Range("A2:C1000"), and, can not be used.

What cell in row 1, to the right of cell D1, can I use?

Let's go for F1 then

 

[hiker95]

ATSJ,

I have not been able to find a working solution using the Worksheet_Change event, and, the Workbook_Open event, to solve your request(s).

And, I have far exceeded the normal amount of time I allocate for solving problems/requests from web sites like MrExcel.

Click on the Reply to Thread button, and just put the word BUMP in the thread. Then, click on the Post Quick Reply button, and someone else will assist you.

 

[ATSJ]

ATSJ,

I have not been able to find a working solution using the Worksheet_Change event, and, the Workbook_Open event, to solve your request(s).

And, I have far exceeded the normal amount of time I allocate for solving problems/requests from web sites like MrExcel.

Click on the Reply to Thread button, and just put the word BUMP in the thread. Then, click on the Post Quick Reply button, and someone else will assist you.

No problem whatsoever, I very much appreciate your help.

 

[hiker95]

ATSJ,

Click on the Reply to Thread button, and just put the word BUMP in the thread. Then, click on the Post Quick Reply button, and someone else will assist you.

 

[ATSJ]

No problem, I believe I have reached a solution using some Conditional Formatting. It's more of a workaround than anything else but it does what I want. Many thanks bud.

 

[hiker95]

I have reached a solution using some Conditional Formatting

ATSJ,

Nicely done. Glad that you were able to find a solution.