Hello,
I am making a document that when a activex checkbox is checked(true) then it will reveal hidden rows beneath that have activex checkboxes that will also reveal hidden rows when checked(true). My difficulty is having the activex checkboxes dissappear and reappear with their intended rows. As you can see from the attached photo, my checkboxes appear in the wrong area. Is there a way to lock the checkboxes into a cell or just a way to make them hidden when a checkbox unchecked(false). I know some coding but do not know syntax of VBA and the capabilities. Essentially the below code shows a brief glimpse of what I am trying to do.
Rows 18:19 ,22 rely on the "Yes" checkbox of row 17.
Rows 20:21 rely on row 19 "Yes" checkbox.
Rows 23:24 rely on row 22 "Yes" checkbox.
Private Sub Hide()
If CheckBox210.Value = True Then
[18:19,22:22].EntireRow.Hidden = False
[20:21,23:24].EntireRow.Hidden = True
CheckBox213.Hidden = True
CheckBox214.Hidden = True
CheckBox215.Hidden = True
CheckBox216.Hidden = True
CheckBox217.Hidden = True
CheckBox218.Hidden = True
'Else: [18:24].EntireRow.Hidden = True
CheckBox213.Hidden = True
CheckBox214.Hidden = True
CheckBox215.Hidden = True
CheckBox216.Hidden = True
CheckBox217.Hidden = True
CheckBox218.Hidden = True
'End If
'End Sub
Any help would be greatly appreciated. Thank you!
Bookmarks