#1
|
|||
|
|||
Checkbox - toggle hide/unhide other checkboxes and their texts
Hello,
I am new to VBA and I'm trying to create an document with 3 checkboxes, where each of them shows a specific text when checked, I managed this with bookmarking the text. But I would also like to hide the other 2 checkboxes when one checkbox is checked, is this possible? And I would also like them to appear again if I uncheck the box. Here is the VBA code I've used so far, I also attach the document: Private Sub CheckBox1_Click() ClickEvent CheckBox1 End Sub Private Sub CheckBox2_Click() ClickEvent CheckBox2 End Sub Private Sub CheckBox3_Click() ClickEvent CheckBox3 End Sub Private Sub ClickEvent(ctrl As msforms.CheckBox) Dim sBookmarkName As String With ThisDocument Select Case ctrl.Name Case "CheckBox1": sBookmarkName = "TextToHide" Case "CheckBox2": sBookmarkName = "TextToHide2" Case "CheckBox3": sBookmarkName = "TextToHide3" End Select .Bookmarks(sBookmarkName).Range.Font.Hidden = _ Not ctrl.Value End With End Sub |
#2
|
|||
|
|||
A checkbox doesn't have a "Visible"property, but you can come close:
Private Sub CheckBox1_Click() If CheckBox1 Then With CheckBox2 .Width = 1 .Height = 1 .Enabled = False End With With CheckBox3 .Width = 1 .Height = 1 .Enabled = False End With Else With CheckBox2 .Width = 108 .Height = 18.6 .Enabled = True End With With CheckBox3 .Width = 108 .Height = 18.6 .Enabled = True End With End If End Sub |
#3
|
|||
|
|||
Hello,
thank you for the answer. I guess thats one way to get around and solve the problem, thank you! Best regards |
Tags |
checkbox, hide, vba |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Checkbox - toggle hide/unhide other checkbox - XMLMapping | GErl | Word VBA | 9 | 11-19-2020 03:15 PM |
Toggle Collapse/Expand via Content Control Checkbox | metaflowdesigns | Word VBA | 5 | 07-08-2020 02:53 PM |
Hide and Unhide Rows If.... | Marcia | Excel Programming | 2 | 03-20-2020 07:25 PM |
Hide / unhide Rows | NullVBA | Excel Programming | 4 | 12-09-2015 05:10 AM |
Hide/Unhide pictures | maloneb | PowerPoint | 1 | 01-18-2012 03:34 PM |