VBA to select rows based on selection

  • Thread starter Thread starter HowOnEarthDoI
  • Start date Start date
H

HowOnEarthDoI

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.
 
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
 
Back
Top