vba - Excel does not recognize combo box when file is opened -
i have 9 text boxes, 2 command buttons , 4 combo boxes excel chooses not recognize 1 of combo boxes (combobox4 in case) when file opened after saving. not code complicated either. following error upon opening file:
"run-time error '424': object required" line 3 or line 5 depending on combobox1's value when file saved.
private sub combobox1_change() if combobox1.value = "single fitment" combobox4.enabled = false else combobox4.enabled = true end if end sub
thank you.
Comments
Post a Comment