Hi,

I'm trying to apply data validation to a range of cells, the rules are that
the user must enter a numeric value 0, or enter 0, the cell can't just be
left blank.

Any help is welcome.

I don't think Data Validation is going to do that. What is the driver that
is going to force the user to do anything? In other words, what do you want
to happen if the user doesn't follow your rules?
An example of what can happen: If the user doesn't follow the rules, and
attempts to close or save the file, a message box will pop up saying
whatever you want it to, and the file will nor close or save. The driver,
in this instance, is that he can't close or save the file if he doesn't
follow your rules. So the question is back to you; what do you want to
happen if the user doesn't follow your rules? HTH Otto

"LaDdIe" wrote in message
...
Hi,

I'm trying to apply data validation to a range of cells, the rules are
that
the user must enter a numeric value 0, or enter 0, the cell can't just be
left blank.

Any help is welcome.

LaDdIe wrote:
Hi,

I'm trying to apply data validation to a range of cells, the rules are that
the user must enter a numeric value 0, or enter 0, the cell can't just be
left blank.

Any help is welcome.

You can set validation to whole number and a specific range, but you
cannot prevent the user pressing return on an empty cell. You would have
to move the test for ISNUMBER() into whatever the next stage is.

NB A blank cell looks to some Excel numeric functions like zero.

Regards,
Martin Brown

Thanks Otto,

I guessed as much, I decided to go the VBA route and knocked up some code
that bounce back to the previous cell if that cell was left blank.

"Otto Moehrbach" wrote:

I don't think Data Validation is going to do that. What is the driver that
is going to force the user to do anything? In other words, what do you want
to happen if the user doesn't follow your rules?
An example of what can happen: If the user doesn't follow the rules, and
attempts to close or save the file, a message box will pop up saying
whatever you want it to, and the file will nor close or save. The driver,
in this instance, is that he can't close or save the file if he doesn't
follow your rules. So the question is back to you; what do you want to
happen if the user doesn't follow your rules? HTH Otto

"LaDdIe" wrote in message
...
Hi,

I'm trying to apply data validation to a range of cells, the rules are
that
the user must enter a numeric value 0, or enter 0, the cell can't just be
left blank.

Any help is welcome.

.

Thanks Martin

"Martin Brown" wrote:

LaDdIe wrote:
Hi,

I'm trying to apply data validation to a range of cells, the rules are that
the user must enter a numeric value 0, or enter 0, the cell can't just be
left blank.

Any help is welcome.

You can set validation to whole number and a specific range, but you
cannot prevent the user pressing return on an empty cell. You would have
to move the test for ISNUMBER() into whatever the next stage is.

NB A blank cell looks to some Excel numeric functions like zero.

Regards,
Martin Brown
.