When you say "remove the validation in D1 so I can manually input a
name/value in it", Do you mean that:-
You want to add a name to the validation list for D1 or
You simply want to remove the validation from D1 and type a name into D1 or
You want to type a name into D1 and add it to the validation list and then
reinstate the validation for D1 with the extra name in it.

--
Regards,

OssieMac


"NoodNutt" wrote:

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.