Hide rows with checkbox

gebobs · #1 03-24-2015, 07:05 AM

OK...so I figured out part of it. I was using a form control. I did the same with an ActiveX control and the hide/unhide worked swimmingly. Other than that, I really don't know what the difference is between the two types. Is there a way I can get this to work with the form control? Which type is better to use? Are there advantages of one over the other?

Snakehips · #2 03-24-2015, 12:05 PM

gebobs,

ActiveX controls have arguably more properties that are readily set / read via the vba editor Properties pane and thus easy code.

Coding for form control properties is perhaps not so obvious but there are several ways you can refer to them.

One nice thing about using Form objects is that you can style and format them so much better than ActiveX

Try coding for your form checkbox as below.

Code:

Sub cbClaimHide_Click()
  If ActiveSheet.CheckBoxes("cbClaimHide").Value = 1 Then
    [47:53].EntireRow.Hidden = True
    Else: [47:53].EntireRow.Hidden = False
  End If
End Sub

Hope that helps.

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