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

Similar Threads

Add a new row in Named Table (Table1) and add data from txtboxes into last empty cells based on header named of the Table1 0
hiding or showing rows based on a cell value 6
Average cells based on column header 6
Excel Excel hide/ unhide row based on checkbox 0
Hide and Show Rows based on Cell Value 2
How to Hide and Unhide Rows 2
A macro to hide rows 5
Hide Rows and Columns based on Date Input 6

Back
Top