Unanswered: Using checkbox tu hide row in macro excel
Hi everyone...can anybody help me...i already create a form in excel..in my form have drop down list and checkbox...i'm using macro in excel but i do not know how to hide row when i click the checkbox in my form....the form must like this when i click chekbox some row must hide but when i'm uncheck the checkbox the row must appear again....using macro VB coding i mean...
i hope anybody can understand what i mean and can help me..sorry my english so bad ...thank you...
Private Sub CheckBox2_Click()
Application.ScreenUpdating = False
If .Value = True Then
Rows("30:59").EntireRow.Hidden = False
Rows("30:59").EntireRow.Hidden = True