View Single Post
 
Old 03-24-2015, 12:05 PM
Snakehips Snakehips is offline Windows 8 Office 2013
Advanced Beginner
 
Join Date: Mar 2015
Posts: 36
Snakehips is on a distinguished road
Default

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.
Reply With Quote