VBA Message box display when cell value is changed, with a condition

Hi all,

I'm struggling with a code for some time now. I need, when a cell value in a range is changed, a message box to popup asking if i really want to change the cell value. When clicking yes in the message box, the value will be changed. When clicking no, the code undo the previous step, and the original message comes back. The message will not affect if empty cells value was not changed.

I need to adjust the code so the message box appears if i change value in a cell which is not empty.
If i insert value in empty cell, it should not do nothing.

It Will be good, but not essential to my request, if the message displays both the old and the new value, asking which one i wish to keep.

I hope I've explain it clearly.

Thank you in advance for the help.

Cheers
Igor

Please Login or Register  to view this content.

Keebellah, i see your point. It seems that i need to leave the pop-up. I've also tried to undo the last action, copy the value, and redo to the last entered value, hoping that with this i will get both of the original and new value. But I've entered in infinite loop and my excel crashed.

Still, thank you for your help.