Prevent message from popping up twice

[gdome]

I want to prompt the user with an error message if they have entered too many categories in their selection. My current code is as follows:

If Range("F44") <> "" And WorksheetFunction.CountA(Range("F6:F15")) = 10 Then

MsgBox "You can only enter a maximum of 9 categories if this is selected. Please delete one of the categories above."
Range("F15").Select​

End If

Now, this works fine but the problem is that the error message pops up again when the macro selects F15.

Is there a way to prevent the message from popping up when F15 is automatically selected?

Thanks!

 

[djreiswig]

Maybe

Application.EnableEvents = False

before the selection command and

Application.EnableEvents = True

after the selection command?

 

[gdome]

that works. should have thought of that myself!

thanks heaps!