I'm using the Worksheet_Change event to capture when changes are made to various cells on my spreadsheet (then those trigger various macros). In one case, I need to capture the value that was in the cell before "0" was keyed so I can make some adjustments requiring me to subtract the prior amount from a subtotal.

Typing "0" is what triggers my event...but that's too late. My prior value is gone. I've seen that if this was a Form there is a BeforeUpdate event...but I'm not using a Form...

Any suggestions on how I can capture that value before it is changed?

This may be prohibitive, based on how many cells you need to monitor, and there is probably a better way, but what I would do is setup a variable for each cell, or an array of variables for the cell.

On the On_Change event, check to see if the new value is 0, if so you can pull the old value out of the variable and use it, or if it isn't 0, assign the new value to the variable.

Hope that helps,

Mike

Mike
EchoVue.com

Thanks, Mike. I may give this a try. There aren't that many values I'd have to keep up with and should be able to do it fairly easily with an array.

As I'm often told, "a good plan today is better than a perfect plan tomorrow."

Thanks again!

Cinda