• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Toggle Button for Rows

I have a worksheet being used as a Input forms. The problem is that it has over 40 input fields but half of the fields are option fields. I would like to hide those row cell and let user unhide the row cell when they need to input the data. This way they will be able to get to what they need to faster. Do anyone know where and example of how this can be done.
 
Hi Clarence,

One method use AxtiveX Option button and use below code:

Code:
Private Sub CheckBox1_Click()
If CheckBox1.Value = True Then
Sheets("Sheet2").Range("A6").EntireRow.Hidden = True
Else
Sheets("Sheet2").Range("A6").EntireRow.Hidden = False
End If

End Sub

See the file for working. Row 6 is HIDE when you select Check Box.

Regards,
 

Attachments

  • toggle row.xlsm
    20.8 KB · Views: 5
Back
Top