Userform combobox compare and add new line to table

Hi,

I'm super burned out after working on this userform for the past 12 hours and am hoping someone has a quick fix for me that I can implement many times for most of my comboboxes thus solving a large piece of this userform. When the user enters a customer name into a combobox (instead of selecting one), upon exiting the combobox I'd like its value to be compare to a specific table (i.e. CustomerTable) and if the name does not exist in the table, column 1, then it will add that value to the table. I know it sounds easy, but I'm dead tired since I'm doing this on my own time. Then I'll be able to modify the provided compare&edit function for other uses. Danke!

Luke

Hi Luke,

look at the file.