Excel VBA combox box disable
- by Chase
Hi all,
I am trying to enable/disable a combobox based on the value or state of a second combobox in Excel 2007.
I think my code should look something like this:
Sub DropDown266_Change()
If DropDown266.Index = 2 Then
DropDown267.Enabled = False
End If
End Sub
However, I am getting a run time error '424' saying an object is required. I am sure this is a very simple change, but I can't seem to figure it out. Let me know if you need more details.
Thanks,
Chase