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...

Hi, is this any use to you?

Private Sub CheckBox2_Click()
Application.ScreenUpdating = False
With Sheet2.CheckBox2
If .Value = True Then
Rows("30:59").EntireRow.Hidden = False
Else
Rows("30:59").EntireRow.Hidden = True
End If
End With
Sheet2.Range("A1").Select
End Sub

Jez

thank's ya...it's really use...thank's you so much..!!

**akuccputsedut**
Intelligent is Me!!But a little confusing
sometimes needs HELP!!