ensuring at least one checkbox is checked from a group

  • Thread starter Thread starter fcinelli
  • Start date Start date
F

fcinelli

Hi,

I am making a "wizard" and one part has 5 checkboxes (of the same
groupname). I want to prevent the user from clicking my next button
unless he/she has clicked at least one checkbox.

Is there a way to go through each checkbox in this group without having
to do an if statement for each one? Or at least what is best way to
accomplish this?

Thanks
 
Link the checkboxes to 5 contiguous cells, and run a SUMIF against them.

--
---
HTH

Bob

(change the xxxx to gmail if mailing direct)
 
Back
Top