Worksheet VBA to display message box

[Keibri]

Hi All,

If it is not too much of an inconvenience to ask, I have the following workbook code, which basically will display a message box if it finds a 1, in range O5:O1004.

Please Login or Register  to view this content.

Would it be possible to amend it to include a second message box which will be displayed, if it finds a 2 in range P5:P1004?

Appreciate a lot your kind help!

Thanks


Keibri

[Richard Buttrey]

Do you mean as well as or instead of.

Trivially of course you could just add another block of code

Please Login or Register  to view this content.

Personally if there are checks like this that need to be made in VBA I find it easier to create an IF() type formula in Excel, give it a range name then read the value of that name in VBA and process accordingly. e.g. if the check name in Excel was a range called "Check", in VBA

Please Login or Register  to view this content.

[Keibri]

Thanks for your suggestions !