Hide & Show Rows based on Check Boxes

  • Thread starter Thread starter loza
  • Start date Start date
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
 
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

Back
Top