if txtbox < "blahblah" and txtbox < "nextone" and txtbox <"anotherone"
then

you want to use AND. It will always not equal one of the values, so using
OR would always be true.

--
Regards,
Tom Ogilvy

"novicevbaer " wrote in message
...
Tom

Thank you for responding. I was trying to put

If txtbox < "blahblah" Or "nextone" Or .........

This didnt work. Is there a way to list all of the possible variables
otherwise it would only work if there were only one possible acceptable
word.

Thanks I know this is on the right track


---
Message posted from http://www.ExcelForum.com/