Hello,

I have a sort of login form so that when the workbook opens, the use
enters a user name which automatically enters their budget into th
appropriate cell. I tried using a combo box with required matc
function but the problem is I don't want anyone to know what words ar
on the list to prevent them seeing other budgets.

I worked around this by adding

If txtbox = blahblah then budget =

This works fine. Now, I wondered if there is some code to add to sa
that if textbox does not equal one of the words listed then the use
cannnot pass the log in form.

How do you say if txtbox is NOT equal to blah blah or blahbla
then....

I hope I have asked this clearly.

I appreciate any help. THank you

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