On Sep 16, 3:29 pm, BJ wrote:
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.