Changed Data with Date

DaLiMan

Active Member
Joined
Jun 1, 2004
Messages
295
Hi there,

Is there a (simple) way to write a date in a field when an item is changed? And is this possible for every item seperately?
 

Excel Facts

Remove leading & trailing spaces
Save as CSV to remove all leading and trailing spaces. It is faster than using TRIM().
It all depends on how you're changing the record.
Under the assumption that you're using a form to work with a table, this is pretty easy. First, start by using your own buttons to navigate through the table (next/previous) instead of the defaults. Second, throw in code that tests for changes in the records and if one is found, add the date time stamp.

What I'm not certain of is the best way to compare values.
You might try the 'Dirty' event (triggered if a field is changed) but this might be triggered if a user were to edit a field then change it back to the original value.

You might need to do something funky like save the entire record to an array as you navigate to it...and then compare before you move on.

I have a feeling I'm not looking at the easy answer and the latter is cumbersome.

Mike
 
Upvote 0

Forum statistics

Threads
1,221,700
Messages
6,161,371
Members
451,700
Latest member
Eccymarge

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top