Data Validation w/o Cell Content Deletion

[BJ]

I would like to allow users to change a cell value as long as it is a whole
number between 0 and xxx,xxx. I can do this with Data Validation. However,
I don't want the user to be able to 'Delete' the cell contents which result
in the cell having a value of "". I only want them to be able to change the
cell to another value within the Data Validation range.

How can I do this?

Thanks.

BJ

 

[Spiky]

I would like to allow users to change a cell value as long as it is a whole
number between 0 and xxx,xxx. I can do this with Data Validation. However,
I don't want the user to be able to 'Delete' the cell contents which result
in the cell having a value of "". I only want them to be able to change the
cell to another value within the Data Validation range.

How can I do this?

Thanks.

BJ

Use a combobox instead of an in-cell dropdown.