I have two activeX combo boxes in an excel sheet where the selection in the first box determines the values displayed in the second box. When a user clicks combo box 1, the vba code monitors the selection and then populates the values of combo box2 and drops down combo box2.
My problem is that when I save the excel workbook under another name this triggers the click event of the combo box1. So I lose the selected value in combobox2 and am presented with the drop down menu with nothing selected.
I tried deactivating combobox1 after selecting a value for combobox2 but the same thing happened when using "Save As".