In my current worksheet, I have a setup for each individual person, and with
2 of my fields I have in list boxes, Title (Mr,Mrs,Miss,Ms) and Gender
(Male,Female). I would like to be able to put a condition in place that would
show an error message if Female was entered into the Gender field when Mr was
selected, and if Mrs,Miss,Ms was selected when Male was chosen in the gender
field.

Is there anyway of doing this, considering they are both list boxes?

See response in worksheet.functions

--
HTH

Bob Phillips

(there's no email, no snail mail, but somewhere should be gmail in my addy)

"Alex" wrote in message
...
In my current worksheet, I have a setup for each individual person, and
with
2 of my fields I have in list boxes, Title (Mr,Mrs,Miss,Ms) and Gender
(Male,Female). I would like to be able to put a condition in place that
would
show an error message if Female was entered into the Gender field when Mr
was
selected, and if Mrs,Miss,Ms was selected when Male was chosen in the
gender
field.

Is there anyway of doing this, considering they are both list boxes?