+ Reply to Thread
Results 1 to 2 of 2

How to make a check box work.

  1. #1
    Forum Contributor
    Join Date
    05-05-2004
    MS-Off Ver
    Office 365
    Posts
    651

    How to make a check box work.

    I need to make a checkbox allow a section of cells a10-c20 to be seen only if the checkbox is checked.

    Sub CheckBox32_Click()

    Sheets("Summary").Shapes("Button 2").Visible = Sheets("Summary").Visible = Sheets("Summary").Range("E3")

    End Sub


    This is the macro I use to display a new button if a checkbox is checked in another spreadsheet I have but I dont know how to display an group of cells. Do I simpaly make the text color White when its not checked and Black when it is? Or is there another way?

    Thanks in advance.

  2. #2
    Forum Contributor
    Join Date
    05-05-2004
    MS-Off Ver
    Office 365
    Posts
    651
    Lame Bump.

+ 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