| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Removing Data Validation (Listbox)
Hi everyone
Is there a way of removing validation from a specific cell after a value is selected from another cell (List). assume I have a validated "Company" list in Column A and the validated "Employees Names" listed in column D eg After selecting "...Unlisted" from cell A1, can I then using VB to remove the validation in D1 so I can manually input a name/value in it. TIA Mark Also could really use help on the following which I posted already, but as yet have recieved no responses to, just need to know if it is possible. Example: If I select XYZ Trans from validated "Company" list in Column A, I would like the validated "Employees Names" listed in column D to display only the names of the employees for that company. Once again TIA Mark. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| ListBox to display data between two dates | Excel Discussion (Misc queries) | |||
| Setting and filter Listbox data | Excel Discussion (Misc queries) | |||
| listbox B conditional of input in Listbox A | Excel Discussion (Misc queries) | |||
| Setting up a validation of data listbox to provide the unique items within a range | Excel Worksheet Functions | |||
| MSOffice Excel 2003-Validation Listbox takes only 47 values | Excel Worksheet Functions | |||
Threaded Mode
