Excel VBA combox box disable
Posted
by Chase
on Stack Overflow
See other posts from Stack Overflow
or by Chase
Published on 2010-05-02T22:41:20Z
Indexed on
2010/05/02
22:48 UTC
Read the original article
Hit count: 659
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
© Stack Overflow or respective owner