Hello.... I am trying to create user names so that when a user opens th
workbook and enters the user name into a sign on form their store numbe
and specific buying budget is entered into the beginning balance fo
forecasting. I easily did that by saying

If txtUser = apple then budget = $100,000

Now, however, I am wondering what I do if a user enters something tha
is not on the list at all? Is there a way to have the user form entr
compare to a list for validation?

And also, what do I do if the user entry is not validated? I wa
thinking about making the form read only at that point but I'm not sur
how to do this.

Any information or direction would be greatly appreciated as to ho
best to achieve this.

Thank you

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