How to automatically close the dropdown list of an ActiveX ComboBox
I have a little problem. I want the dropdown list of the ComboBox to close when I select another cell or switch to another sheet. For example, if I open the ComboBox in cell G8 and the dropdown list is shown, but I don’t select anything from that list and then select cell A8, the cell A8 is selected but the dropdown list remains open and frozen. The same happens if I switch sheets; if the dropdown list is visible and I switch sheets, the dropdown list remains frozen in the middle of the screen, interfering with the new sheet.