Multiple Checkboxes to Hide/Unhide Rows and/or Columns based on cell values

[gravy258]

Hi Everyone,

I am new to the board and with minimal VBA experience, hoping that someone can help me with the following:

I have a sheet with hundreds of rows and columns, which I want the end-user to easily be able to use checkboxes to hide/unhide any columns or rows they wish based on three sets of values in the column headers and row headers.

Please see the simple example below.. I have tried several different pieces of code for the checkboxes but nothing has worked for both rows and columns yet.

For instance, if a user unchecked all boxes except for "Apples" and "3", it would only display columns with "3" in row 5 and only display rows with "Apples" in column A.

Any help would be greatly appreciated. Thanks to all!

Fruits

Letters

Numbers

Checkbox - Apples

CB - A

CB - 1

Checkbox - Oranges

CB - B

CB - 2

Checkbox - Bananas

CB - C

CB - 3

CB - 4

1

2

3

4

1

2

3

4

1

2

3

4

Apples

a

a

a

a

b

b

b

b

c

c

c

c

Apples

Oranges

Bananas

Bananas

Bananas

Apples

Oranges

Orange

Apples

Bananas

Oranges

Oranges

<TBODY>
</TBODY>