ensuring at least one checkbox is checked from a group

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
 
B

Bob Phillips

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

--
---
HTH

Bob

(change the xxxx to gmail if mailing direct)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

For...Loop to verify at least one checkbox = True 2
Assessing whether any checkboxes are checked within frame 1
XL2002 - Resetting Checkbox values on Multipage Form 2
Trap a checkbox click 6
Require checkbox to be checked before processing 1
Click Checkbox Event 4
Checkbox or Option Button 2
select only one checkbox 2

Top