I have a searchable ComboBox (original VBA came from https://trumpexcel.com/excel-drop-dow…ch-suggestions/) for the customer name. The problem I'm having is, after the ComboBox is filled. The ComboBox continues to reactivate anytime change is made to any other cell on the worksheet and also seems to stay active when the workbook is closed.
I have attached a copy of the worksheet and unprotected it so everything is visible.
Any help on this would be greatly appreciated.