I have 3 Checkboxes each with its own procedures, that is linked to a
command button, like below, but when you select any combination of the
boxes a Msgbox: must pop up saying please select only 1 checkboxs at a
time.
How do i do that?

Private Sub CommandButton6_Click()
If CheckBox1 = True And CheckBox2 = False And CheckBox4 = False Then
Sheet14.Activate
Unload UserForm1
Else
End If

If CheckBox2 = True And CheckBox1 = False And CheckBox4 = False Then
Sheet6.Activate
Unload UserForm1
Else
End If

If CheckBox4 = True And CheckBox1 = False And CheckBox2 = False Then
Sheet1.Activate
Call RunProgramSequence1
Else
End If

End Sub

'MsgBox "Please make only one 'Planning' selection" & Err.Description,
vbExclamation, "AI-Program: Power Utility Pack 2006"


--
T.c.Goosen1977
------------------------------------------------------------------------
T.c.Goosen1977's Profile: http://www.excelforum.com/member.php...o&userid=35895
View this thread: http://www.excelforum.com/showthread...hreadid=558313

Don't use check boxes, use Option button instead.
They are designed to mutually exclusive.

NickHK

"T.c.Goosen1977"
<T.c.Goosen1977.2agmpb_1152082202.8878@excelforu m-nospam.com wrote in
message news:T.c.Goosen1977.2agmpb_1152082202.8878@excelfo rum-nospam.com...

I have 3 Checkboxes each with its own procedures, that is linked to a
command button, like below, but when you select any combination of the
boxes a Msgbox: must pop up saying please select only 1 checkboxs at a
time.
How do i do that?

Private Sub CommandButton6_Click()
If CheckBox1 = True And CheckBox2 = False And CheckBox4 = False Then
Sheet14.Activate
Unload UserForm1
Else
End If

If CheckBox2 = True And CheckBox1 = False And CheckBox4 = False Then
Sheet6.Activate
Unload UserForm1
Else
End If

If CheckBox4 = True And CheckBox1 = False And CheckBox2 = False Then
Sheet1.Activate
Call RunProgramSequence1
Else
End If

End Sub

'MsgBox "Please make only one 'Planning' selection" & Err.Description,
vbExclamation, "AI-Program: Power Utility Pack 2006"


--
T.c.Goosen1977
------------------------------------------------------------------------
T.c.Goosen1977's Profile:
http://www.excelforum.com/member.php...o&userid=35895
View this thread: http://www.excelforum.com/showthread...hreadid=558313

Thanks Nick


--
T.c.Goosen1977
------------------------------------------------------------------------
T.c.Goosen1977's Profile: http://www.excelforum.com/member.php...o&userid=35895
View this thread: http://www.excelforum.com/showthread...hreadid=558313

But if you must use Radio Buttons then you can check to see if the
value of the other radio buttons has been checked. I don't know the
code off the top of my head (I'll check for you if you need it), but
you can say something to the extent

'Inside verification code check the other 2 boxes to see if they are
checked
if(checkbox1 = checked) or (checkbox2 = checked) Then
msgbox "Please only select one checkbox."
'uncheck all boxes
checkbox1.checked = false
checkbox2.checked = false
checkbox3.checked = false
end if

HTH,
Brill2


T.c.Goosen1977 wrote:
I have 3 Checkboxes each with its own procedures, that is linked to a
command button, like below, but when you select any combination of the
boxes a Msgbox: must pop up saying please select only 1 checkboxs at a
time.
How do i do that?

Private Sub CommandButton6_Click()
If CheckBox1 = True And CheckBox2 = False And CheckBox4 = False Then
Sheet14.Activate
Unload UserForm1
Else
End If

If CheckBox2 = True And CheckBox1 = False And CheckBox4 = False Then
Sheet6.Activate
Unload UserForm1
Else
End If

If CheckBox4 = True And CheckBox1 = False And CheckBox2 = False Then
Sheet1.Activate
Call RunProgramSequence1
Else
End If

End Sub

'MsgBox "Please make only one 'Planning' selection" & Err.Description,
vbExclamation, "AI-Program: Power Utility Pack 2006"


--
T.c.Goosen1977
------------------------------------------------------------------------
T.c.Goosen1977's Profile: http://www.excelforum.com/member.php...o&userid=35895
View this thread: http://www.excelforum.com/showthread...hreadid=558313

I would hate such a UI, because checkboxes visually indicate that these
choices are not exclusive, whilst option buttons visually indicate the
opposite.
However, if your aim is to confuse the user, then that would do it.
NickHK

"Brill2" wrote in message
oups.com...
But if you must use Radio Buttons then you can check to see if the
value of the other radio buttons has been checked. I don't know the
code off the top of my head (I'll check for you if you need it), but
you can say something to the extent

'Inside verification code check the other 2 boxes to see if they are
checked
if(checkbox1 = checked) or (checkbox2 = checked) Then
msgbox "Please only select one checkbox."
'uncheck all boxes
checkbox1.checked = false
checkbox2.checked = false
checkbox3.checked = false
end if

HTH,
Brill2


T.c.Goosen1977 wrote:
I have 3 Checkboxes each with its own procedures, that is linked to a
command button, like below, but when you select any combination of the
boxes a Msgbox: must pop up saying please select only 1 checkboxs at a
time.
How do i do that?

Private Sub CommandButton6_Click()
If CheckBox1 = True And CheckBox2 = False And CheckBox4 = False Then
Sheet14.Activate
Unload UserForm1
Else
End If

If CheckBox2 = True And CheckBox1 = False And CheckBox4 = False Then
Sheet6.Activate
Unload UserForm1
Else
End If

If CheckBox4 = True And CheckBox1 = False And CheckBox2 = False Then
Sheet1.Activate
Call RunProgramSequence1
Else
End If

End Sub

'MsgBox "Please make only one 'Planning' selection" & Err.Description,
vbExclamation, "AI-Program: Power Utility Pack 2006"


--
T.c.Goosen1977
------------------------------------------------------------------------
T.c.Goosen1977's Profile:
http://www.excelforum.com/member.php...o&userid=35895
View this thread:
http://www.excelforum.com/showthread...hreadid=558313