Message box needed in VBA

Hi All,

Can any of you please provide me the code for Message box where I have a range of A2:A500 and B2:B500 and C2:C500

If A2:A500 is "Yes" then message should be " Incorrect code"
IF B2:B500 is "Yes" then message should be " Incorrect amount"
IF C2:C500 is "Yes" then message should be " Not Matching"

Thank you so much for your time.

Mitta..