| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Validation Data using Validation Table cell range..... | Excel Discussion (Misc queries) | |||
| Data Validation List content controlled from cell | Excel Worksheet Functions | |||
| copy comment content to cell content as data not as comment | Excel Discussion (Misc queries) | |||
| Automatic cell content deletion | Excel Discussion (Misc queries) | |||
| protect formula in cell and still allow data deletion | Excel Discussion (Misc queries) | |||
Linear Mode
