Another query,

When a user enters a manual entry into the combobox on my userform
want the userform to ask if this entry should be added to the drop-dow
list for future use.

I can manage most of this but I don't know what the statement would b
for determining if the manual entry is in the existing list or not.

if combobox1.value = 'one not in source list' then
call userform2 etc

Can anyone help

--
Message posted from http://www.ExcelForum.com