Want to track the number of times a cell is changed and the date it was last changed

**Ed_V** · 05-07-2014, 12:29 AM

Hi, I'm looking for hep with a macro to:
1. record in Column B the date the value of a cell in column A was last changed
2. record in Column C the number of times the value of a cell in column A has been changed
Thanks

**:) Sixthsense :)** · 05-07-2014, 12:54 AM

Copy the below code and do right click on sheet tab and select view code and paste it.

Close the VBA window (Alt+Q to close VBA window) and return to that sheet and check.

Please Login or Register  to view this content.

**Ed_V** · 05-07-2014, 01:00 AM

Thanks for your help, works perfectly
Cheers

**Ed_V** · 05-07-2014, 01:05 AM

One more question, if I want to do the same thing for changes made to column E recorded in columns F and G what do I need to do to the macro? Ie. I would like to track changes to column A in columns B & C, and track changes to column E in columns F and G

**:) Sixthsense :)** · 05-07-2014, 01:10 AM

.Offset(Row,Column)

We don't need any offsetting for row so I ignored the row part with blank and used only the column part in my code which is given below.

Please Login or Register  to view this content.

Column-B is the Next column of Column-A so only one column offset is enough so used the first line of code .Offset(, 1).Value for entering the date.

Column-C is the Second column of Column-A so two column offset is enough so used the second line of code .Offset(, 2).Value for counting the changes.

So make changes in the offset for adjusting the code

Hope that clear

**Ed_V** · 05-07-2014, 01:27 AM

Sorry I meant I wasn't sure what to do to track the changes made to two columns, A & E. Ie

Record information about changes to A in B & C - as you have solved above
&
Record information about changes to E in F & G

Hope that makes sense

Sorry I have no idea how to write code!

**:) Sixthsense :)** · 05-07-2014, 01:39 AM

Replace the previous code with the below one and check

Please Login or Register  to view this content.

**Ed_V** · 05-07-2014, 02:01 AM

That works perfectly, thanks again!

Want to track the number of times a cell is changed and the date it was last changed

LinkBack

Thread Tools

Rate This Thread

Display

Want to track the number of times a cell is changed and the date it was last changed

Re: Want to track the number of times a cell is changed and the date it was last changed

Re: Want to track the number of times a cell is changed and the date it was last changed

Re: Want to track the number of times a cell is changed and the date it was last changed

Re: Want to track the number of times a cell is changed and the date it was last changed

Re: Want to track the number of times a cell is changed and the date it was last changed

Re: Want to track the number of times a cell is changed and the date it was last changed

Re: Want to track the number of times a cell is changed and the date it was last changed

Thread Information

Users Browsing this Thread

Similar Threads

[SOLVED] Blank Form print 10 times with one cell changed

How to track which user changed a certain cell.

[SOLVED] Date is being changed to a number (problem)

[SOLVED] I need to keep a count of the times a cell is changed

[SOLVED] Count How Many Times A Cell's Value Has Been Changed

Bookmarks

Bookmarks

Posting Permissions