Results 1 to 1 of 1

Hide Checkbox when Row Hides - not working

Threaded View

ker9 Hide Checkbox when Row Hides... 02-14-2011, 01:29 PM
  1. #1
    Forum Contributor
    Join Date
    06-16-2010
    Location
    Tampa, FL
    MS-Off Ver
    Excel 2010
    Posts
    278

    Hide Checkbox when Row Hides - not working

    Hi,
    The results of a selection in a combo box show/hides a group of rows and should also show/hide 6 checkboxes. It hides 4 of the checkboxes but not that last 2 (which are not on the last row being hidden but sort of in the middle. This code changes the property of those checkboxes that aren't hiding to Visible = False appropriately, but the checkboxes are still visible. What am I doing wrong?

    Private Sub cmboCash_Change()
    If cmboCash.Value = "N/A" Then
        ActiveSheet.Shapes("cbCashSig3").Visible = False
        ActiveSheet.Shapes("cbCashFrd3").Visible = False
        Range("GrpCash").EntireRow.Hidden = True
        Range("CashLine").Select
    
    Else
        ActiveSheet.Shapes("cbCashSig3").Visible = True
        ActiveSheet.Shapes("cbCashFrd3").Visible = True
        Range("GrpCash").EntireRow.Hidden = False
        Range("CashStart").Select
        
    End If
    
    End Sub
    SOLVED:
    All the checkboxes were stacked on top of each other when the rows were hidden (but I couldn't tell that visually). Selecting in design mode brought me to the one that was hidden but was on top. The code is working and needed to set up for each checkbox.
    Last edited by ker9; 02-14-2011 at 03:03 PM.

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