Hide & Show Rows based on Check Boxes

L

loza

Hi All
In Cols A5,B5,C5 is my data in D5 I have a checbox named CheckBox1 and have
copied and paste the check box down to D100 as i have 95 rows of data. Need a
vb attached to a command button to show only those rows that are checked and
to show all rows as other people will make there own selection based on the
check boxes
Thanks Loza
 
J

Joel

Check boxes have alinkedcell property that will put in a cell either true or
false. These linked cells can be in a hidden row or on a colun not normally
seen on the worksheet like the last column IV. Use the linked cell to
determine if the check box is checked or not checked.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

hiding or showing rows based on a cell value 6
Best way to insert rows 5
Hide row(s) based on drop down selection 6
Hide and Show Rows based on Cell Value 2
Check boxes, Is this possible? 2
Hide Rows and Columns based on Date Input 6
How to Hide and Unhide Rows 2
Excel Excel hide/ unhide row based on checkbox 0

Top