Pop-up message box only once

[boboivan]

Hi guys!

I have this code to let me know if in range C2:C15 are values less than 7.

Please Login or Register  to view this content.

If in range I have more than one value smaller than 7, the message box (which is a form type) pops-up more than once.
How can I fix that to show the message only once?

Thx!

[Trebor76]

Hi boboivan,

Put this new line of code...

Please Login or Register  to view this content.

...immediately beneath this existing line of code:

Please Login or Register  to view this content.

Regards,

Robert

[boboivan]

Thank you Robert!
Works great.

[Trebor76]

Thanks for letting us know and for adding to my rep

If you could mark the thread as solved it would be appreciated.

Regards,

Robert