There are sample files he

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

Under 'Data Validation'

To do this with formulas, look for 'Flexible Item List'

Or to do it programmatically, look for 'Update Validation List'

Dmorri254 wrote:
Hello,

Does anyone know how to update a validation list just by typing a new value
into the cell with the list. Inotherwords, if I have a validation list in
cell (a) that has apples, oranges and pears, if I type in bananas, I want
that entry to fill my validation list.

Thanx for your help


--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html