Message box needed in VBA

Hi,

Sorry for the confusion caused.

If any of the cell in A2:A500 contains "Yes" message should be "incorrect code" also it would be great help if message tells which cell is incorrect.

Thank you

Hi, I have a sample code here for you to try. It does everything you said except telling which cell is incorrect, but I'm working on that. Is the formatting of the msgbox okay? This will give you all the errors in one msgbox instead of multiple popping up.

Sub test()
Dim x As Long
Dim y As Long
Dim z As Long

x = Range("A" & Rows.Count).End(xlUp).Row
x = Application.WorksheetFunction.CountIf(Range("A2:A" & x), "Yes")
y = Range("B" & Rows.Count).End(xlUp).Row
y = Application.WorksheetFunction.CountIf(Range("B2:B" & y), "Yes")
z = Range("C" & Rows.Count).End(xlUp).Row
z = Application.WorksheetFunction.CountIf(Range("C2:C" & z), "Yes")
If x <> 0 And y <> 0 And z <> 0 Then
    MsgBox ("Incorrect Code, Incorrect Amount, and Not Matching")
ElseIf x <> 0 And y <> 0 Then
    MsgBox ("Incorrect Code and Incorrect Amount")
ElseIf x <> 0 And z <> 0 Then
    MsgBox ("Incorrect Code and Not Matching")
ElseIf y <> 0 And z <> 0 Then
    MsgBox ("Incorrect Amount and Not Matching")
ElseIf x <> 0 Then
    MsgBox ("Incorrect Code")
ElseIf y <> 0 Then
    MsgBox ("Incorrect Amount")
ElseIf z <> 0 Then
    MsgBox ("Not Matching")

End If


End Sub

Hi

Looks fine thank you!!!

It would be great if we are able to find which cell went wrong...

Even if its not possible, could you please add another message stating that "every thing's good - No errors" if there is no Yes in any of cells in A,B& C?

Again... thanks a ton!!

Glad that works for you! To get that no error message just add

Else
MsgBox ("No Errors")

before the End If line.

I'm working on showing the cell for any error. Do you want every cell that has YES in it to be listed as such?

Hi

Yes, It would tell the inputted person which cells are incorrect..

Thank you so much!!

I'm having a difficult time figuring that out. I think it can be done, but it'd require some knowledge I do not possess. Are you against using conditional formatting to highlight cells when they have yes in them? It would be easier to find them that way if you have to change them, since you'll have to write down your list of incorrect cells and then go find them anyway.

Thank you so much... I used conditional formatt and I'm good now!

I'm glad I could help! If my responses were what you were looking for, don't forget to Add Reputation to me by clicking on the star under my posts