Posted to microsoft.public.excel.misc

Mon

Posts: n/a

Display cells when box is checked

I tried VBA code that was posted earlier...
the code is:

Private Sub CheckBox1_Click()
Dim myRng as Range
Set myRng = Me.Range("A20:A29").EntireRow (obviously suited to my range)
myRng.Hidden = Me.CheckBox1.Value
End Sub

What this does is make it so that the rows are showing when the checkbox is
NOT checked and once the checkbox IS checked, the rows are HIDDEN. How do I
make it the other way around? I want to Check the box and have what was
hidden now be visible.
Obviously I'm new at the codes, etc.
thanks!

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
How do I get Excel to display a range of cells with a check box?	bobm	Excel Discussion (Misc queries)	2	October 21st 05 07:37 PM
Display only certain cells	ringersoll	Excel Worksheet Functions	2	October 20th 05 08:19 PM
Cells formated as text do not always display properly	Cass	Excel Discussion (Misc queries)	2	July 23rd 05 01:59 AM
Display empty cells	botany_girl	Excel Discussion (Misc queries)	7	July 19th 05 06:40 PM
Display empty cells	botany_girl	Excel Discussion (Misc queries)	1	July 19th 05 05:51 PM

All times are GMT +1. The time now is 04:27 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us