Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Data Validation
How can I implement a multi-column list for data validation in a worksheet,
i.e., not in user form? I have a worksheet that user needs to pick a vendor from a valid list. I want to show both the vendor number and name on the list, but, I prefer not to use user form to accomplish this. In addition, the validation list does not seem to be as user-friendly as it is in Access, which will jump to the right record as you type. Is there something in Excel that is similar? Your help is appreciated. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Data validation | Excel Worksheet Functions | |||
Macro question | Excel Worksheet Functions | |||
Inputting data to one worksheet for it effect another | Excel Discussion (Misc queries) | |||
named range, data validation: list non-selected items, and new added items | Excel Discussion (Misc queries) | |||
Pulling data from 1 sheet to another | Excel Worksheet Functions |