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?

---
Regards,
Norman



"VB Newbie" wrote in message
...
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!!!

I think I will do that. I thank you, sir!

"Norman Jones" wrote:

Hi VB Newbie,

Why not use Option buttons, which have this functionality?

---
Regards,
Norman



"VB Newbie" wrote in message
...
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!!!