vba clear content

[Undo]

Hello

I need vba code
if user select any cell in range b1:b1000
if the cell was not empty, then user delete cell value and it came empty
then code make clear content only for that cell

Thanks

[Rick Rothstein]

Your question is not entirely clear. Are you saying the user selects some cells with the range B1:B1000 and presses the Delete Key? If so, why would you need to clear the cells' content... the Delete Key would have already remove whatever was in it.

[Undo]

i mean clean content not delete key

i need this because i have another sheet with reference to this cells
if i write in the main cell, the data copied to other sheet, but if i write in cell, then i select cell again and backspace and remove the value for main cell, i got blank cell i second sheet, it must be 0 if nothing there, and after i make clear content for first cell, its solved and second sheet back to 0

i need it 0 because i have another codes when its 0