Excel VBA combox box disable

Question

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

Answer 1

Are you sure DropDown267 exists?

Answer 2

Try using Me.DropDown266.Index

Also you can use Intellisense to check if the Combobox exists: type Me.Dro and see if DropDown266 appears in the list.

Answer 3

Chase... The syntax for getting the index is ComboBox1.ListIndex, I am not sure if thats because I am using Excel 2003, can you try it at your end.

Cheers... Nilesh