| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Hide & Show Rows based on Check Boxes
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 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Hide & Show Rows based on Check Boxes
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. "loza" wrote: 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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Clicking on numbered boxes, plus and minus sign to show and hide d | Excel Discussion (Misc queries) | |||
| Automate display/ hide rows in excel based on yes/no check box | Excel Discussion (Misc queries) | |||
| Can one cell hold multiple check boxes (and then sort based off e. | Excel Discussion (Misc queries) | |||
| Hide Rows - copy and paste only rows that show | Excel Worksheet Functions | |||
| Check boxes to show/hide Tabs | Excel Worksheet Functions | |||
Linear Mode
