Data Validation Query

[Guest]

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?

 

[Bob Phillips]

See response in worksheet.functions

--
HTH

Bob Phillips

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