UncleBajubjubs
Board Regular
- Joined
- Jul 11, 2017
- Messages
- 111
- Office Version
- 2010
Hello,
I have a sheet which outlines a project, and I added checkboxes to each section. This is a quick example showing the checkboxes.
[]1
[] a
[] b
[]2
I used the following code for the checkboxes
My issue is that with the above code, if I hit the check box for item 1, hiding items 1a and 1b, the checkboxes for 1a and 1b are not hidden, but instead stack on the checkbox. Is there a way to correct this?
Thanks.
I have a sheet which outlines a project, and I added checkboxes to each section. This is a quick example showing the checkboxes.
[]1
[] a
[] b
[]2
I used the following code for the checkboxes
VBA Code:
Sub CheckBoxControls()
With ActiveSheet.Shapes(Application.Caller).ControlFormat
Range("LEControls").EntireRow.Hidden = (.Value = xlOff)
End With
End Sub
My issue is that with the above code, if I hit the check box for item 1, hiding items 1a and 1b, the checkboxes for 1a and 1b are not hidden, but instead stack on the checkbox. Is there a way to correct this?
Thanks.