Record Value Change from a Live Feed

**jk64** · 06-23-2011, 01:20 PM

I need VBA code that records the number of times a cell in a worksheet has a value change.

For example if cell J5 contains the live feed, if thatl value is changed to this would be recorded as 1 in the cell using the recording function. If that Cell value is then changed to 11, the cell change would be recorded as 2.

I'm really new to all this code stuff so help would be very much aprreciated.

I've tried using this and lsight variations, but none have worked:

Please Login or Register  to view this content.

**p24leclerc** · 07-08-2011, 11:33 PM

I rechecked this code and found it was not really working like you wanted it to so I worked it out again and came up with a code the keep tracks of all past values of the cell you want to check and it also record time of change and who changed it.

HERE IS THE NEW CODE

Please Login or Register  to view this content.

You have to set the Sheet3 the first time you start your counter. I mean delete all but the first 2 rows. Input the first and actual value of the cell and fill the other 3 columns.

You might want to hide the Sheet3 so no one will see or change it.

**DonkeyOte** · 07-09-2011, 03:30 AM

Can you elaborate regards "live feed" ? If you're referring to a DDE then a Worksheet_Change event along the lines of the above will not work I'm afraid.

If you are indeed referring to DDE then you might consider using some Static variables and the Calculate event else assigning the DDE target cell to a control which would in turn fire it's own change event as and when the DDE target updated.

Your initial code implies DDE and use of Statics, however, you must remember to update OldVal when incrementing.