How do I get Excel to display a range of cells with a check box?
I put a checkbox from the control toolbox toolbar on a worksheet.
I doubleclicked on that checkbox (named checkbox1) and put this code in that
visible code window:
Option Explicit
Private Sub CheckBox1_Click()
Dim myRng As Range
Set myRng = Me.Range("a10:A20").EntireRow
myRng.Hidden = Me.CheckBox1.Value
End Sub
Then back to excel (click on that design mode icon also on the control toolbox
toolbar) and try checking that box.
bobm wrote:
I am trying to get excel to disply a range of cells when a check box is
checked and hide them when it is not checked.
--
Dave Peterson
|