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