Message when 8 checkboxes are checked in a Userform

Hi, I hope someone can give me a hand on this.

I have a userform with 10 checkboxes. I want to have a message alerting me that 8 checkboxes were already checked when I click on specific sheet.

Thanks in advance

i believe all userforms, when active, are modal aren't they? what that means is that you cannot click on anything underneath them when they are in front of you on the screen. I don't know for sure, but i seem to remember that. can you confirm that you can actually click on a worksheet when the userform is present on the screen?

if you can, you can use the worksheet_activate() event to check what you need to check. userforms are qualifying objects for all of their controls, I think. thus, something like this (not exactly this) should work just fine:

Please Login or Register  to view this content.

This met my requirement, thank you so much

Originally Posted by fabian_76

This met my requirement, thank you so much

great! have a good day.