Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
User Name From List
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Data validation list decreases as the user chooses from the list/s | Excel Discussion (Misc queries) | |||
data validation list: how do i 'force' a user to enter data from the list? | Excel Discussion (Misc queries) | |||
data validation list: how do i 'force' a user to enter data from the list? | Excel Discussion (Misc queries) | |||
User Form List Box | Excel Programming | |||
User Form / List Box | Excel Programming |