Data Validation

[Alex H]

Hi

I have some cells which validate to ensure that users dont enter a value of
more than 5. This works Ok until users in clearing the contents, use the
space bar and not the clear content function.

Is there a way i can validate data to allow either cell = null, blank or
anything up to 5.

Thanks

Alex

 

[Peo Sjoblom]

Tell the user not to do that, it is like typing text into a cell, clear the
cell
using the menu or record a macro clearing the cell and attach the macro to a
button
you call Clear. Otherwise I assume something like this will work using
custom under the validation menu

=AND(B1<=5,B1=" ")

 

[Alex H]

Thanks a lo Peo

I do tell them that, but who am I a mere IT techie...

I sometimes would like to pop up a big sign saying DUMMY when they do that

Alex

 

[Peo Sjoblom]

Sorry, wrong formula,

=OR(B1<=5,B1=" ")

where B1 is the cell with validation

 

[Alex H]

LOL - yes I saw that one !

Cheers

Alex

Sorry, wrong formula,

=OR(B1<=5,B1=" ")

where B1 is the cell with validation

--

Regards,

Peo Sjoblom


macro blank