Data validation lists

[dpaton05]

If I have a data validation list as the source in A1. The Source of the list refers to B1:B10. Can you add new items to a data validation list by typing over the item in A1 as whenever I do that, I get told that the item is not in the list?

 

[shaowu459]

A better way is add item in B11 and data validation use dynamic formula to expande range fro B1:B10 to B1:B11.

 

[Michael M]

You can change the list to accept "Any Value" then ste the data type when the msgbox pops up