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.
Bookmarks