VBA IF statement not working.....

[lukeshuttlewood]

When i try to run the IF below i get this error, any ideas why?

Run time error 13
Type Mismatch


If Originator Or ProposedActionee Or Approval1 Or Approval2 Or Approval3 Or Approval4 Or Approval5 Or Approval6 = UserNames Then

All the variables are as type string. Basically each of these variables are peoples names eg "LUKE.SHUTTLEWOOD". If "LUKE.SHUTTLEWOOD" is equal to the UserNames variable then do X else do Y.

I dont know why i get type mismatch when all variables are string??!!

 

[Andrew Poulsom]

You have to repeat the equality test for each variable, eg:

If Originator = UserNames Or ProposedActionee = UserNames Or Approval1 = UserNames Or Approval2 = UserNames Or Approval3 = UserNames Or Approval4 = UserNames Or Approval5 = UserNames Or Approval6 = UserNames Then

 

[lukeshuttlewood]

I should know that!! duh!!

thankyou