Hello,

I'm not sure if its possible or not, im trying to built an audit trail for excel, however, as far as I have researched it seems you can only do it for one cell at a time, so im wondering if there is a way to get the value when multiple cells are changed and record them one by one.

I have put a detection message when multiple cells are select perhaps thats the only thing to do, if so is there any way to keep the PreviousValue instead of deleting them when multiple cells are selected.

This is the code i have managed to get so far. Im no expert in VBA, just putting things together, and trying to make sense of what i find online and the basic principle.

Also I was hoping perhaps someone can guide me how to add more error checks, making it less prone to fail.

Thank you in advance.

Please Login or Register  to view this content.