+ Reply to Thread
Results 1 to 5 of 5

Hide a checkbox when hiding the row it is in

  1. #1
    Forum Contributor GuruWannaB's Avatar
    Join Date
    01-24-2008
    Location
    An hour due East of Cowtown Ohio
    MS-Off Ver
    2010
    Posts
    421

    Hide a checkbox when hiding the row it is in

    I found this thread which is exactly what I want to know as well - however I am somewhat VBA familiar. I need to know how I can hide checkboxes in a row when I hide the row. Currently, when the row is hidden, the checkboxes are still visible and scruncth up. Any suggestions?


    Thanks in advance
    Last edited by VBA Noob; 11-12-2008 at 03:27 AM. Reason: Move to own thread as Hijacking Threads not allowed

  2. #2
    Forum Expert royUK's Avatar
    Join Date
    11-18-2003
    Location
    Derbyshire,UK
    MS-Off Ver
    Xp; 2007; 2010
    Posts
    26,202
    What does the check box do? You can make a cell act as a check box with some VBA
    Hope that helps.

    RoyUK
    --------
    For Excel Tips & Solutions, free examples and tutorials why not check out my web site

    Free DataBaseForm example

  3. #3
    Forum Contributor GuruWannaB's Avatar
    Join Date
    01-24-2008
    Location
    An hour due East of Cowtown Ohio
    MS-Off Ver
    2010
    Posts
    421
    It is a flag for information that will be presented on a chart, there are up to 15 possible data lines that can be plotted and I've created it so as the user can select which, if not all, data lines they would want charted - by using the checkmark boxes.

  4. #4
    Forum Expert royUK's Avatar
    Join Date
    11-18-2003
    Location
    Derbyshire,UK
    MS-Off Ver
    Xp; 2007; 2010
    Posts
    26,202
    If you can substitute the cell value for the checkbox value it would be easier

  5. #5
    Forum Contributor GuruWannaB's Avatar
    Join Date
    01-24-2008
    Location
    An hour due East of Cowtown Ohio
    MS-Off Ver
    2010
    Posts
    421
    My problem is this...I need a true/false value for 15 data lines. The users of this are going to be ...well...let's just say they are not the brightest pears that fell off the apple tree...they are management. Everything needs to be basically point and click with the mouse.

    I have four possible uses of the same spreadsheet which the user can pick from. The rows containing the instructions for the other three uses are surpressed and hidden - which one of them has checkmark boxes (remember, point and click). I have since found that I can use

    Please Login or Register  to view this content.
    will work...but when I go to make it visible again, it doesn't always appear on the row I originally placed it. Any other suggestions? The key is that it has to be point and click and not keyboard oriented for the user.
    Last edited by VBA Noob; 11-12-2008 at 01:47 PM. Reason: Added code tags as per forum rules

+ 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