Layout pop-up with checkboxes

[Nicolas Mous]

Dear reader,

Recently I received a file with my made kilometers and costs in 2012. I wanted to put all this information in a excel sheet but besides putting it in a sheet I wanted to create a pop-up layout in which the data returns (but more readable). So for example when I click the month button January, a pop-up will be shown with the data of that month in it (this is data like driven km, liters fueled, fuel costs and so on).
I would like to add a function to this layout which has to do with checkboxes, for example when I click January I only want to see certain data like; liters fueled and driven km but not all the other data.

My question is, is this possible and how could I create it? I was thinking about using a userform for the layout and use the checkboxes to define the data. In the attached example I have created 2 sheets, 1 with all the data (just for 2 months with made up data just to give you guys an idea) and 1 sheet with how the layout should look like.

I am however not a genius with VBA and got no clue how to create this with a userform, my userform and checkbox knowledge is about 5% so I would be working on it for probably the rest of my life. Also need to have a good solution for the checkbox, ideally the checkboxes would be in the userform and when I click something in the checkbox the data of the clicked button will show.

Hope it makes a bit of sense.

Thank you in advance!


Nicolas
(Attached the data and how it should look like - to give you an idea)

Test format pop-up with checkbox.xlsx

[oeldere]

Another approach.

Why not just work with an filter to get your result.

Another option would be pivot table.

[Nicolas Mous]

Thank you for your fast reply!

The thing is i want to use 2 format layouts to show, 1 total layout which is different in colors and text size ect. (but also in data), and 1 format that shows specific month information only or total information (with less data then in the total layout format).

Never worked with a pivot table before - did a bit of research about it 5 sec ago - so also got no clue how to create/use it


Nicolas

[oeldere]

In that case just stick to the filter.

That would give exactly what you need.

Another advice, don't work with merged cells, you get in trouble with it sooner or later (and it's mostly sooner).