CheckBox Selection
Solved/Closed
azmiismail
Posts
17
Registration date
Thursday March 3, 2011
Status
Member
Last seen
July 20, 2011
-
Apr 8, 2011 at 07:06 AM
TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen December 27, 2022 - Apr 11, 2011 at 08:53 AM
TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen December 27, 2022 - Apr 11, 2011 at 08:53 AM
Related:
- CheckBox Selection
- Screenshot excel selection - Guide
- Multiple selection photoshop - Guide
- Insert checkbox in word - Guide
- Virtualbox temporary boot device selection - Guide
- Could not use the quick selection because there is not enough memory - Guide
1 response
TrowaD
Posts
2921
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
December 27, 2022
552
Apr 11, 2011 at 08:53 AM
Apr 11, 2011 at 08:53 AM
Hi Azmiismail,
When you look at your userform in VB, right-click on Checkbox1, select view code and paste this code:
Right-click on Checkbox2, select view code and paste this code:
Now you will not be able to select both checkboxes; selecting one will deselect the other.
Best regards,
Trowa
When you look at your userform in VB, right-click on Checkbox1, select view code and paste this code:
Private Sub CheckBox1_Click() If CheckBox1 = True Then CheckBox2 = False End Sub
Right-click on Checkbox2, select view code and paste this code:
Private Sub CheckBox2_Click() If CheckBox2 = True Then CheckBox1 = False End Sub
Now you will not be able to select both checkboxes; selecting one will deselect the other.
Best regards,
Trowa
