| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| I need to create a simple checkbox that has true false outputs | Excel Discussion (Misc queries) | |||
| Stop renaming or moving sheet tabs | Excel Discussion (Misc queries) | |||
| Linked Check Boxes | Excel Discussion (Misc queries) | |||
| Disable CUT via toolbars or shortcut keys | Excel Discussion (Misc queries) | |||
| Disable "Cut" only | Excel Discussion (Misc queries) | |||
Linear Mode
