Doing it a bit manually, you could have the DV list in a worksheet range,
say A1:A10, and refer to this in the DV definition dynamically, that is
using a formula of

=OFFSET(A1,,,COUNTA(A:A))

If the user finds a value not in the list, the just append to A1:A10, or
whatever it has grown to.

--

HTH

RP
(remove nothere from the email address if mailing direct)


"waltersanglea" wrote in
message ...
I am not sure if this can be done but here goes...

I have a cell with a drop down list and I am using Data Validation to
control this list. I need the user to be able to add to this list if
he/she does not find the item that they need. For example, the list
contains cat, dog, and fish but the user needs to use bird. Since
bird is not in the list I want the user to be able to add bird. So
now the list is cat, dog, fish, and bird.

Can this be done? If so, please give me some pointers or other places
to research.

Also, I would like to learn more about programming in excel and to
learn more about what the functions can do for me. Does anyone know
where I should start looking?

Thanks for your help!