Handling "Blank Entries" through Data Validation

J

Jai

Hi,
I am using a single column list of values to restrict data entry in a
worksheet column of cells. It works except that it does nothing if the cell
is left blank - though blank is not a part of the list. I checked and
unchecked "Ignore Blank" and only while reading through some discussions did
I realise that these blanks refer to blanks in the list and not in the
entered value itself.

The question is how do I handle a blank entry in the cells ?

Jai
 
D

Dnereb

check for len(cells(X,Y)) = 0
I dont know if you are using a formula or VBA but this will be the
general concept
 
J

Jai

Thanks Dnereb. In my application however, I do not know how many rows of
entries will be made on the sheet. Perhaps I need to enter the formula in all
columns. But then, if the code is to prevent further action till the blank
value is filled in, the cells in the yet to be filled rows will also swing
into action to jam the works. It would have been great if, on getting focus,
the data validation took over.
Jai
 
Top