![]() |
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 |
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