Evaluate multiple combobox values

[sharky12345]

Can someone help me with this please, it's one area of VBA which I have never been able to truly understand no matter how hard I try;

I have 3 Comboboxes on a Userform, named ComboES1, 2 and 3.

I want a routine to run when the Comboboxes are changed to do other bits in the following circumstances;

1) If ANY of the 3 Comboboxes are blank do nothing

2) If any have a value of "YES" (subject to the other 2 not being blank as above)

3) If any have a value of "NO" (subject to the other 2 not being blank)

I can sort out the bits that need to run if the condition is met, it's creating the conditions that confuses me.

Thanks guys.

 

[Johnny C]

Re: Evalute multiple combobox values

Hi
I'm not sure I understand what you're asking. Just the logic when a combo box changes, or how to tell when a combo box changes?

If it's the logic then is this what you mean?

If ComboES1.Value = "" Or ComboES2.Value = "" Or ComboES3.Value = "" Then
    'Do nothing
Else
    If ComboES1.Value = "Yes" Or ComboES2.Value = "Yes" Or ComboES3.Value = "Yes" Then
        'Do something else
    Else
        If ComboES1.Value = "No" Or ComboES2.Value = "No" Or ComboES3.Value = "No" Then
            'Do something else
        End If
    End If
End If

Do you know what you want to do if 1 has already changed to "Yes" and you've run the code, then the user selects "No" in another. Or vice versa.

 

[sharky12345]

Re: Evalute multiple combobox values

Hi Johnny,

Thanks - I'll give your suggestion a try. In essence I want the evaluation to run every time each combobox changes, if that makes sense. I'll try your suggestion and report back.