Data validation lists
 

how to create a combo box from a name range, and if you add data to the combo
box if not in list add it to the range in excel with vba

--
Message posted via http://www.officekb.com