Counting checkbox values

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi-

Can anyone assist me with a quick script on checkbox values? I have
userform1 with 7 checkboxes. I want to set a control for the following:

if more than one checkbox.value for checkboxes 1-7 = true then
msgbox("Please select one and only one checkbox.")
exit sub.
end if

I thank you kindly!!!
 
Hi VB Newbie,

Why not use Option buttons, which have this functionality?
 
You must log in or register to reply here.

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

CheckBox 2
Arrays and Checkboxes 3
Set value of checkbox on userform without triggering Click event 7
VBE tricky question 2
Create Checkbox and link to relative Cell 3
Textbox Validation and Associated Checkbox 6
Show checkbox checked on open 4
Checking and Unchecking CheckBoxes using code 3

Back
Top