ExcelBanter - Data Validation w/o Cell Content Deletion

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - Data Validation w/o Cell Content Deletion (https://www.excelbanter.com/excel-worksheet-functions/202750-data-validation-w-o-cell-content-deletion.html)

Data Validation w/o Cell Content Deletion

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

Data Validation w/o Cell Content Deletion

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.

All times are GMT +1. The time now is 09:18 AM.