Ask user to confirm delete action

Hi,

I'm trying to prompt user when he tries to delete a value from a cell so he can confirm is action but not the same way to all cells.
Let's say that I have cells A1:F10 with values, and user should be able to change this values but not to delete them (can't be a blank cell) and I want to prompt him that info (something like "Cell can't be blank!").
In other range a want a different thing: let's say cells H1:K20. In this cells user should be able to change cells values and also delete them but I want to ask him for a confirmation (something like "are you sure").

Can someone help me?

PS: My VBA is not so good.

Something like:

Please Login or Register  to view this content.

in the worksheet object module.

Check this one.

ragulduy,
Thank you a lot. That works perfectly.

Nobody can help me with this problem when deleting merged cells values?

Checked my solution?

haripopuri, thank you very much for your reply but in a quick test on your solution it seems like it isn´t working the way I need it. But thank you for your help!

Anyway, I found a solution to the problem in ragulduy's code, that wasn't working on merged cells.
On: " If target.Value = "" Then "; we should have: " If target(1).Value = "" Then ".
That solved it!

Thank you very much for your help!