Hi Corey

Sure. If the entry is not in the list then the combobox'es ListIndex is -1. So if it's -1 then add the value to the list.

HTH. Best wishes Harald

"Corey" skrev i melding ...
Hi all,

Need some help.

If a comboBox list is a set range from a worksheet, and as in my case it is a list of customer names.
When selected it creates a new worksheet and pastes the selection into a cell.

But if the customer is Not in the list, can i have the New customer added to the range somehow by code from the combobox value ?

Corey....