Hiding checkboxes

Hi there,

I've had some issues with this before, when you hide or change the row height the checkbox behaves differently. I think the only way you can accomplish this is by "toggling" the visibility of the checkbox. You should be able to do it with some VBA.

Don't use CheckBoxes, use this code to simulate CheckBoxes in Column A

Please Login or Register  to view this content.

Just change it to this

Please Login or Register  to view this content.

Note: there's no need to quote previous replies in your posts

Thanks for the rep.

If you are satisfied with the solution(s) provided, please mark your thread as Solved.

How to mark a thread Solved
Go to the first post
Click edit
Click Go Advanced
Just below the word Title you will see a dropdown with the word No prefix.
Change to Solved
Click Save

I solved the checkbox delima by resizing the checkbox so that the control frame fits inside the host cell. Now I can hide rows and do not have the "stacking" problem. I have encountered new new problem in that I am using a Form Control Option Button to hide/unhide blank rows but cannot get the macro to function correctly. Just so you know - I am macro illiterate and know next to nothing about them or how they work. Here is the code I copied and modified for my use: The purple portion is what is highlighted during debugging.


Sub Hide_Unhide()

Dim Rng As Range
Dim MyCell As Range
Set Rng = Range("E4:E103") (If a value is entered in this range then show row, if blank then hide row)
For Each MyCell In Rng
If MyCell.Value = "" Then
MyCell.EntireRow.Hidden = ActiveSheet.CheckBoxes(Application.Caller).Value = xlOn
End If
Next MyCell

End Sub

Your post does not comply with Rule 3 of our Forum RULES. Use code tags around code. Posting code without them makes your code hard to read and difficult to be copied for testing. Highlight your code and click the # at the top of your post window. For more information about these and other tags, found here

Rubix, you've continued your post in the wrong thread