How to restrict pop of message box inside multiple times when it is inside a for loop?

Hi,
I have a for loop in my code below , it will avoid copy pasting the wrong values into the excel cells. If we copy and paste one value in one cell , Message Box will pop-up once and it is fine. But when we copy paste multiple cells for example say 10 cells , then the message box will pop-up 10 times and need to press OK 10 times to close the message which is very hard if the no.of cells increase say 50 or 500.

Is there any way to restrict this situation ? to pop-up only once though we copy multiple cells (which are wrong) and paste in sheet so that message will pop-up only once for all 10 or 50 or 500 cells

For Each cl In rng.Cells
If cl.Validation.Value = False Then
MsgBox ("Error : Please select the correct values from the drop-down")
End If
Next

Thanks
mounika

Hi,
I have a for loop in my code below , it will avoid copy pasting the wrong values into the excel cells. If we copy and paste one value in one cell , Message Box will pop-up once and it is fine. But when we copy paste multiple cells for example say 10 cells , then the message box will pop-up 10 times and need to press OK 10 times to close the message which is very hard if the no.of cells increase say 50 or 500.

Is there any way to restrict this situation ? to pop-up only once though we copy multiple cells (which are wrong) and paste in sheet so that message will pop-up only once for all 10 or 50 or 500 cells

Please Login or Register  to view this content.

Thank
Mounika

Thanks Miroslav R. It helped me thank you thank you