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 t
control this list. I need the user to be able to add to this list i
he/she does not find the item that they need. For example, the lis
contains cat, dog, and fish but the user needs to use bird. Sinc
bird is not in the list I want the user to be able to add bird. S
now the list is cat, dog, fish, and bird

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

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

Thanks for your help