Hide rows with checkbox

gebobs · #1 03-23-2015, 02:16 PM

OK...so I have a form with several rows that I would like to hide/show based on the value of a checkbox. There are some other checkboxes in this are that I want to hide with the rows that they are on. However, when I go to the Format Control: Properties, the Move and Size with cells option is grayed out. Any idea why that's happening?

Also, here is the macro...

Code:

Private Sub cbClaimHide_Click()
  If cbClaimHide = True Then
    [47:53].EntireRow.Hidden = True
    Else: [47:53].EntireRow.Hidden = False
  End If
End Sub

Regardless of whether it is checked or not, it always goes to else. What the heck have I screwed up?

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Show/Hide Text based on Checkbox Selection	tammytran105	Word VBA	7	10-02-2014 04:30 PM
Delete rows using checkbox in word	deboer	Word VBA	5	06-22-2014 05:21 AM
Hide Checkbox When Printing	vinceplunkett	Word	1	12-03-2013 01:53 AM
Hide Rows	YounesB3	Excel	2	10-29-2012 05:40 AM
VBA for CheckBox to Hide Slides	mutchy25	PowerPoint	1	09-21-2012 01:40 AM