mardi 15 août 2017

if condition with "and" combine "multiple or" in Vba Excel

I have been making validation in macro vba...

How to make if condition with "and" combined with "multiple or" in vba?

Here is my code:

If (not cook = True) And (if (exp_gas > 0) or (exp_woodburn > 0) or _
    (exp_oil > 0) or (margarine > 0)) Then
    MsgBox "He doesn't cook", vbInformation 

End If

it gives me syntax error

Aucun commentaire:

Enregistrer un commentaire