I have a combobox on a userform which references a column of data on a worksheet for it's values. My question is, is there a way to add any new data the user may type in to the masterlist on the worksheet? I'm looking for a way to check a range for specific criteria, and if that criteria doesn't exist, paste it to the end of that range.

Any help would be greatly appreciated!