ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   If one checkbox = true (https://www.excelbanter.com/excel-discussion-misc-queries/107206-if-one-checkbox-%3D-true.html)

damorrison

If one checkbox = true
 
How do I only get one checkbox to = true, I have this code but I have
to check the box a couple of times for it to work

Private Sub LeftBox_Click()
If LeftBox = True Then
Label3.Caption = "Left"
Else: Label3.Caption = " "
End If

If LeftBox = True Then
RightBox = False
End If

If LeftBox = True Then
BothBox = False
End If

End Sub


Bob Phillips

If one checkbox = true
 
Use optionbuttons, that is how they work.

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"damorrison" wrote in message
ups.com...
How do I only get one checkbox to = true, I have this code but I have
to check the box a couple of times for it to work

Private Sub LeftBox_Click()
If LeftBox = True Then
Label3.Caption = "Left"
Else: Label3.Caption = " "
End If

If LeftBox = True Then
RightBox = False
End If

If LeftBox = True Then
BothBox = False
End If

End Sub





All times are GMT +1. The time now is 07:19 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com