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

Popular posts from this blog

javascript - Karma not able to start PhantomJS on Windows - Error: spawn UNKNOWN -

c# - Display ASPX Popup control in RowDeleteing Event (ASPX Gridview) -

Nuget pack csproj using nuspec -