userform combobox remove a certain item

hello again. I am looking for some help with comboboxes and removing items from the list.

so what i have is a userform that i will call from an activeworkbook. when i initialize the form the activeworkbook name is populated into a textbox. i have a combobox with a list of workbook names including the activeworkbook name. i am hoping there is a way to find the activeworkbook name in the combobox list and remove it. the list will not always be in the same order so the activeworkbook name will not always be in the same position in the list

should look something like this

textbox activeworkbook.name combobox name
name
name
name
activeworkbook.name ** this is what i want removed from the list

thanks

well im not sure if your code will work but i solved the issue another way. i just went back to when i filled the combobox list and excluded the active workbook name from being entered in the first place.

thank you for the help