Update vba code through user input.

This is how I would do it, store the list on Sheet1, which can be very hidden.

The code in the combobox exit event checks if the entry is listed, if not there's an option to add it to the list