Update a cell with Date/Time when a cell in that row has changed...

[AdamS25]

Okay, so to start things off, I have been decently good with excel for a while, but I haven't really messed with coding until recently. I have searched for this problem and found something that almost works. I am hoping someone out there has an idea, as I have been searching for a while regarding this problem. Here is what I have so far.

Please Login or Register  to view this content.

This works just fine when I enter data into the fields manually. However, to alleviate, future unforeseen problems via user input. I have created a user form that inputs data into a log with who did it, so that we can track entries and fix problems when they arise. The data is then pulled to the main sheet and the numbers are updating according to the entry that was made. The problem with this code is that it doesn't track when those changes are made, I'm assuming because its a formula and its just an automatic calculation. So, is there a change to the coding I can do, or is there maybe a better way to do this? Thank you for all the help, I was unable to find this exact issue on here, if I missed it, please let me know. Thank you!

[AlphaFrog]

You are correct in that the Worksheet_Change event procedure does not trigger with a formula calculation.

One possible way around that is to trigger off of the precedent cells within the formula that the user changes. I can't get specific without better understanding the nature of your "user form".

Is the" user form" another worksheet or a VBA userform?
What are the formulas in the columns?

Perhaps you can attach an example workbook.

[AdamS25]

It is a VBA Userform.

I have two columns that are updated based on a keyword as you can see in the formulas. The rest of the cells in the row are simple Sum() formulas.

The userform has a radio button which inputs that word into the log and is read by the front end and makes the change. The formula's I am using are...

Adjustments Column:

Please Login or Register  to view this content.

Orders Column:

Please Login or Register  to view this content.

The orders column is removing the previous orders total and replacing it with the new total. Basically it stops the people filling out the data from having to do math.

I hope that makes sense. If not let me know and I will try to clarify it a little better.

[AlphaFrog]

Is Data the sheet with the formulas and where you want to stamp the date in column A?

Not sure I follow your layout, but if you're using a VBA userform to add entries, it could also stamp the date. Even if if has to find the correct row on another sheet.

[AdamS25]

That is correct, I wasn't quite sure how to do that. The userform has a drop down for which row the data being entered is applied to. How would I go about having the form timestamp it? (As that sounds like an easier method) Originally I tried doing a MAX() type formula to search for the "Key" field and put the date of last entry in the column, but I couldn't quite figure that out. Maybe I was just missing something simple. Here is an example of what the sheet 'Data' looks like:

Date Field	Blank	Number	Record ID	Starting Balance	Adjustments	Current Amount Allocated YTD	Credits	Total Ordered	Available Funds
TIMESTAMP	BLANK	1	QWERTY	$1000	$2500	$3500	0	$(2500)	$1000

[AdamS25]

Here is an example of the 'Log'. I have a date field, which is why I originally tried to use MAX(), but couldn't get it to work.

Record ID	Adjustment Amount	Completed By	Date of Adjustment	Type of Adjustment	Previous Amount	Reason
QWERTY	$2500	Me	7/5/2017	Balance	0	Funding Approved