Data validation combo box lookup
 

Hi after using the following and adding I notice my data validation no longer
works when someone adds something not in the list without double clicking to
use combo box any suggestions greatly appreciated.

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