Checkbox macros hide and unhide selected rows

Hello,

I would like to make this sheet show the data that is checked off. If the data is not checked it should be unhidden.

Could someone help me with this?

Thanks,

Jdata entry.xlsx

I think I get what you are looking for. If the checkbox is checked then you want to show those corresponding rows. If not, then hide the rows.

Please see that attached workbook. I switched to an ActiveX checkbox. ActiveX controls are easier to work with in my opinion.

I created one that corresponded to your checkbox Project-Level Variables.

I also named a range called "ProjectLevelVariables" based on the data you wanted to hide or show. I then used the following event macro for my ActiveX checkbox:

Please Login or Register  to view this content.

This code is in the sheet module for the corresponding sheet where the ActiveX control is.

Let me know if this is what you were aiming for.

I will let you finish the creation of controls and code for the rest of your boxes.

g8r777,

This is exactly what I am looking for. I didnt think ActiveX would be easier but I guess you made it look easy. Many Thanks.
But how come I can not click on the box you created?

And if I want the same kind of correspondence on another sheet in the same workbook how does that work out?

Thnk you and your brain so much.

xladept,

thank you for replying too! any ideas on the new questions? Thanks

Click on the developer tab at the top of the screen. If you are in "Design Mode" then you will not be able to check or uncheck the box. Out of "Design Mode" you should be able to have the box work properly.

The event code (in this case "CheckBox1_Click) should be in the sheet module of the sheet where the check box is. For example, if you have a checkbox on Sheet5, the code that runs when that checkbox is clicked should be in the Sheet5 module.

That doesn't mean that the code can only do things to Sheet5. You could always reference other sheets in the code.

Hope that makes sense and helps.

This works well. One more thing, if the subscription box is checked, how would I hide rows 16 to 27 and rows 44 to 122? And if the project lvl and subscription box was checked off to hide rows 64 to 122?

Thnx

Thank you both for your help. As you can tell I am very new to this. Many thanks

@ jasonexcels

Welcome to the forum.

Based on your last post it seems that you are satisfied with the solution(s) you've received but you haven't marked your thread as SOLVED. I'll do that for you now but please keep in mind for your future threads that Rule #9 requires you to do that yourself. If your problem has not been solved you can use Thread Tools (located above your first post) and choose "Mark this thread as unsolved".
Thanks.

Also, as a new member of the forum, you may not be aware that you can thank those who have helped you by clicking the small star icon located in the lower left corner of the post in which the help was given. By doing so you can add to the reputation(s) of those who helped.