Issue Check Box validation, once check box must be ticked in range

Hi, I have a sheet with 26 active x checkboxes, I am wanting to incorporate some validation so one of the checkboxes must be ticked before an action can be completed. So far I have had some great help from this forum to send me on my way, and need this part to complete my sheet. In this case it is something very simple I am missing!

The code below checks which checkboxes are checked and depening on which will email to a particular email address. I have tried introducing a case whereby if none of the checkboxes are ticked a message will be displayed. I have been looking at this for so long now I just cant get my else clause working.

Please Login or Register  to view this content.