If range value change, active cell equal date and time of change.

**kmakjop** · 03-31-2015, 11:56 AM

Hello

I have a very simple one here, I want for range "W4:W700" if the value change, then the active row "AH" shows the date and time of change. I already have the date and time format, i just cant seem to get it working. Kindly assist.

**Arkadi** · 03-31-2015, 12:06 PM

In the VBA editor, double click the name of the sheet you want this to happen in. Then pasted this code:

Please Login or Register  to view this content.

**kmakjop** · 03-31-2015, 02:26 PM

Thank you Arkadi, it worked perfectly.

Originally Posted by Arkadi

In the VBA editor, double click the name of the sheet you want this to happen in. Then pasted this code:

Please Login or Register  to view this content.

**Arkadi** · 03-31-2015, 02:43 PM

Terrific kmakjop

Please mark the thread as solved then?
And thanks for the rep

If range value change, active cell equal date and time of change.

LinkBack

Thread Tools

Rate This Thread

Display

If range value change, active cell equal date and time of change.

Re: If range value change, active cell equal date and time of change.

Re: If range value change, active cell equal date and time of change.

Re: If range value change, active cell equal date and time of change.

Thread Information

Users Browsing this Thread

Similar Threads

Change cell value to zero if greater than or equal to one in a range

Need date range in cell to change every time button is hit.

[SOLVED] A range value is equal to a cell value but be able to change

How to change the date on a cell if it's equal to another date from a set list?

Change active cell when pasting date from another workbook

Bookmarks

Bookmarks

Posting Permissions