+ Reply to Thread
Results 1 to 1 of 1

Hiding Check Boxes In VB excel 2007.

Hybrid View

  1. #1
    Registered User
    Join Date
    03-13-2012
    Location
    BG
    MS-Off Ver
    Excel 2010
    Posts
    1

    Hiding Check Boxes In VB excel 2007.

    Re:http://www.excelforum.com/excel-prog...el-2007-a.html

    ChemistB; This code will hide the rows and the checkbox when your first checkbox is checked and will unhide them when it is not checked.
    Sub CheckBox1_Click()
    If CheckBox1.Value = True Then
        Rows("34:35").Hidden = True
    ActiveSheet.Shapes("Check box 1").Visible = False
    ElseIf CheckBox1.Value = False Then
        Rows("34:35").Hidden = False
    ActiveSheet.Shapes("Check box 1").Visible = True
    End If
    Hi,
    ChemistB
    I am reading your post and can't help but to ask if this can be modified for multiple check-boxes ?
    What do you think...
    Thank's
    Last edited by davesexcel; 03-13-2012 at 07:01 PM.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1