Viewing multiple columns if multiple check boxes are checked.

[davidingilbert]

Hello all -

I am trying to program my spreadsheet so that if someone clicks multiple checkboxes, multiple columns are able to be viewed side-by-side.
For example, 2 checkboxes, 2 columns. 3 checkboxes, 3 columns.

The code I currently have is -

Please Login or Register  to view this content.

The button I am using is an ActiveX control checkbox.

Appreciate your assistance.
Dave

[TRICKYT57]

I know your question is in the VBA section, and this is not a VBA answer. However it may point you to a simpler solution.
(See the attached spreadsheet)

In Excel you can use "Custom Views" to view the spreadsheet in a certain way. You can make as many custom views as you want,
and select the one you want.

For example you have a view called "Showing all columns", where nothing is hidden.
You can then make a view called "John" which displays columns A,B, and E (hiding columns C and D).
Then you could have a view caller "Peter" which displays columns A,C and E (hiding columns B,D and E)
And Mike Displaying A,D, and E etc..


How to do it:
1) Click on the View Tab
2) Click on the sub-menu tab "Custom Views" (See below if this is greyed out)
3) Click the "+" sign and make the first view "Showing all Columns"
4) Now hide some columns, and make a new view called "John" by clicking View, Custom Views, "+"
5) Repeat to make as many views as you want.
6) To choose a view simply click View, custom Views, and select the one you want.

What if the "Custom Views" is greyed out?
a) Do you have two tabs at the bottom highlighted? Only one sheet should be open. Click on just one tab.
b) Do you have tables anywhere? Convert them to ranges. (Select the entire table, Click Table, Convert to range)
Don't panic about losing Table functions. You can still sort, filter and make Pivot Tables.
If you still need the sorting and table functions, just click on the top row of your table (after converting it to a range),
and click Data, Filter. You will have the table sort and filter functions as well as keeping and using pivot tables.

Open the attached spreadsheet to see this working without VBA

VBA
All you need to do is put Step 6 into VBA code.