jeudi 20 octobre 2016

Why do multiple consecutive unequal conditions not work in vba?

I was wondering why the following syntax does not work the way I thought it would in VBA, and what I should do to ensure it does;

For a = 1 To 10
    For b = 1 To 10
        For c = 1 To 10
            If a <> b <> c Then
                MsgBox (a & " " & b & " " & c)
            End If
        Next c
    Next b
Next a

This is a simplified example, which can still be manually obtained with:

if a<>b and b<>c and c<>a then

But my actual intended code has 10 such variables multiple times, which makes it unfeasible, or likely for me to make a typo. I think there is a more efficient way but I have not found it.

Ps. My goal is to only have a message box pop up if all the variables are unique.

Aucun commentaire:

Enregistrer un commentaire