As others have pointed out this is not a code site, thus plain old English.
First, You need a static variable to store the previous value, static because it should not vanish from memory after your ‘current’ event is over.
Then, You need to set said variable after an input is checked in your event to have it ready for the next time.
so, this is how it goes:
static varible here
inside your event sub:
checking the variable to see if this is the first run
use previous value from variable
set current value from input to variable
If you need the variable to persist between runs you should store it in a cell instead of static variable.
P.S. I’m not doing this to hurt you or hate you or make a point; It’s a simple reason, “This is how you can learn.”
solved How to make textbox to remembers the previous input in Excel VBA?