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?

Thread Tools
Show Printable Version Email this Page
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

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