Results 1 to 3 of 3
  1. #1
    Join Date
    Jun 2007
    Posts
    35

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

  2. #2
    Join Date
    Apr 2007
    Location
    Stalybridge, Manchester
    Posts
    273
    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

  3. #3
    Join Date
    Jun 2007
    Posts
    35

    thank's a lot....!!!

    thank's ya...it's really use...thank's you so much..!!
    **akuccputsedut**
    Intelligent is Me!!But a little confusing
    sometimes needs HELP!!

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •