| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
reverse a "hide" function
Current code:
Private Sub CheckBox1_Click() Range("A10:A28").EntireRow.Hidden = CheckBox1.Value End Sub I need to reverse the checkbox. Currently, when it is checked, the rows hide. I need it to do the opposite. Anyone? Thanks D |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
reverse a "hide" function
Use NOT
Private Sub CheckBox1_Click() Range("A10:A28").EntireRow.Hidden = not CheckBox1.Value End Sub "DarrenL" wrote: Current code: Private Sub CheckBox1_Click() Range("A10:A28").EntireRow.Hidden = CheckBox1.Value End Sub I need to reverse the checkbox. Currently, when it is checked, the rows hide. I need it to do the opposite. Anyone? Thanks D |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Text "comparison" operator for "contains" used in an "IF" Function | Excel Worksheet Functions | |||
| Where did the "Hide PivotChart field buttons" function go in 2007? | Excel Discussion (Misc queries) | |||
| Hide function: "Cannot shift objects off screen"? | Excel Worksheet Functions | |||
| "general" cells turned into "accounting" - why and how to reverse | Excel Worksheet Functions | |||
| Please add a "sheet" function like "row" and "column" functions | Excel Programming | |||
Hybrid Mode
