About combo boxes

[karaeloko]

Hi,
If I have 2 combo boxes (activex), how do I enable/disable the second combo box depending on what is chosen in the first one.

Thx in advanced for any help.

 

[joerd]

Put something like the following in the ComboBox1_Change event procedure:

    Select Case ComboBox1.Value
        Case 1
            ComboBox2.Enabled = True
        Case 2
            ComboBox2.Enabled = True
        Case 3
            ComboBox2.Enabled = False
        Case 4
            ComboBox2.Enabled = True
    End Select

Cheers,
Joerd

Please see FAQ731-376 for tips on how to make the best use of Eng-Tips.