Reloading and limiting comboboxes in UserForm

Hi guys,

First of all thank you for anyone who takes their time to read this, and please note that I am just starting in the world of VBA. So I may not understand everything the first time around.
(Bear with me)

I currently have two comboboxes (Dropdown), when I choose something in No. 1 it will then eliminate something in combobox 2.
I have this nailed, however if someone chooses something in 1 that they didn't mean to, then the option in combobox2 is gone forever!

What would the best approach be to prevent this? Reloading the initialization upon change, having a reset button or maybe a third option I haven't thought of?

Currently I have tried reloading the initialization.

It is my understand that by making the initialization a public sub I can call it anywhere, meaning I try to reload it if anything changes in the combobox.
However I am struggling with executing this. As far as I can tell the if not works fine, but when I reload the initialization it creates duplicates… So something is off, or can you not define a specific piece of text that you don't want to replace? Or do I need to go by List like when removing item (How?)

Please Login or Register  to view this content.

Please Login or Register  to view this content.