Data Validation problem

[Dave]

Could someone tell me what's wrong with this:

On Sheet1 there are option buttons. The result of the
option buttons (1,2,3) are stored in the worksheet called
Service Codes, which will be hidden in the end).

I want to make sure a service code is selected, so I have
set cells S9 through S37 to have data validation set like
this:-
Worksheets("Service Codes").Range("ServCode").Value >1

I can see that ServCode is not 0 but it still comes up
with the error alert message.

Clues, anyone?

 

[Naz]

Hi Dave,

I can't make out what your validation is trying to do.
Couldn't you simply set the validation to "List" and then
select ServCode as the source?

Naz

 

[Dave]

Naz, I want to make sure that one of the option buttons
has been selected. The test is ServCode >0. The ServCode
is important because, if it is not selected then
calculations later on in the spreadsheet will not work.

Thanks for your interest in helping.
Dave