I am using XL 2002

I have a cell in which I have set it's values to a validation list of sales people. Is is possible to update the list by having the user type in a new sales person's name and then have code add the name to the validation list? I don't think so, but I thought that I would ask the experts

Thanks

Joe

Hi
see
http://www.contextures.com/excelfiles.html

and look for the example file:
Update Validation List


--
Regards
Frank Kabel
Frankfurt, Germany


Joe wrote:
I am using XL 2002.

I have a cell in which I have set it's values to a validation list of
sales people. Is is possible to update the list by having the user
type in a new sales person's name and then have code add the name to
the validation list? I don't think so, but I thought that I would
ask the experts.

Thanks,

Joe