Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
VBA to select rows based on selection
I have a workbook with multiple sheets.
One sheet is a selection page, containing multiple tick boxes I would like to display/hide certain rows on another sheet, based on what was selected (ticked) on the first sheet. Have searched on the web for the last week or so, to no avail. It's driving me insane! Any help would be more than welcome. Thanks. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
VBA to select rows based on selection
something like this (you haven't provided many details):
if checkbox1.value = true then activeworkbook.worksheets(2).range("a1").entirerow .hidden = true else activeworkbook.worksheets(2).range("a1").entirerow .hidden = false end if maybe it gets you started........ i assume that checkbox1 is on the activesheet, and the rows you want hidden/not hidden are on worksheet(2). susan On Oct 20, 12:15*pm, HowOnEarthDoI wrote: I have a workbook with multiple sheets. One sheet is a selection page, containing multiple tick boxes I would like to display/hide certain rows on another sheet, based on what was selected (ticked) on the first sheet. Have searched on the web for the last week or so, to no avail. It's driving me insane! Any help would be more than welcome. Thanks. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Select rows based on keyword? | Excel Discussion (Misc queries) | |||
Deleting Rows Based Upon ListBox Selection | Excel Programming | |||
Delete Multiple Rows based on Selection | Excel Programming | |||
Select rows based on criteria | Excel Worksheet Functions | |||
Hide Rows based on Time Selection in timesheet. | Excel Programming |