ensuring at least one checkbox is checked from a group
 

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

ensuring at least one checkbox is checked from a group
 

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

--
---
HTH

Bob

(change the xxxx to gmail if mailing direct)


wrote in message
ups.com...
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