"wana be xl master" wrote in
message ...
Hi there,

I'm using Workbook_SheetChange event. How can I capture the cell value
before user press delete button, then through the if statement if the
condition fails I want to put back the same value on the cell.

Appreciate any help.
Thanks,

Use Worksheet_SelectionChange.
I've not tested, but I expect that Worksheet_SelectionChange
occurs before the user does ant hanky panky in a selection..