Hi all,

I've been searching high and low but can't seem to find the VBA code that will do the following (I have attached an example sheet to make things a bit more clear). On sheet 1 of my workbook I have a couple of checkboxes with different fruits checked for different options (1,2,and 3); comboboxes are linked to underlying cells, giving true/false. Sheet 2 contains various rows with column A always displaying the fruit name (this example only contains a few rows, but my data has more than 1200). Also a combo box is present on sheet 2 which contains the three options mentioned on sheet 1. I'm trying to figure out a code which depending on the choice in the combobox, and depending on which checkboxes are checked on sheet 1, will show/hide rows on sheet 2. So for example, if option 1 is chosen; based on the checked checkboxes on sheet 1, all rows with Mango, Cherry and Pineapple in column A should be displayed. The rest of the rows should be hidden.


Example.xlsm


Would really appreciate some help.