View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
BJ BJ is offline
external usenet poster
 
Posts: 51
Default 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