Message box needed in VBA

[mitta235p]

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..

[patel45]

explain better please, if all cells in range A2:A500 are "Yes" then message should be " Incorrect code" ? or one ?

[mitta235p]

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

[bcas77]

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.

Please Login or Register  to view this content.

[mitta235p]

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!!

[bcas77]

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

Please Login or Register  to view this content.

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?

[mitta235p]

Hi

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

Thank you so much!!

[bcas77]

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.

[patel45]

attach a sample file for testing

[mitta235p]

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

[bcas77]

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