Hello
I could need some help to write a code that can hide/unhide rows with checkboxes.
I would like the sheet to have row 7:247 to be hidden at startup. Then I have checkboxes that will unhide 20 rows a time.
So when the first checkbox is checked, row 7:26 should show, and of course become hidden again if it's unchecked. The next checkbox should unhide/hide row 27:46, and so on.
Could someone please help me?
Thanks!
so like this how many checkboxes u want on userform to do your stuff ?
Thanks - Naveed
-----------------------------
If the suggestion helps you, then Click * to Add Reputation
To Attach File: Go Advanced>>Manage Attachments>>Add Files (In Top Right Corner)>>SelectFiles>>.........Locate Your File(s)>>Upload Files>>Done (In Bottom Right)
1. Use [code] code tags [\code]. It keeps posts clean, easy-to-read, and maintains VBA formatting.
2. If you are happy with a solution to your problem, mark the thread as [SOLVED] using the tools at the top.
I would like there to be a total of 12 checkboxes. So if all the boxes are checked, all the 240 rows that initially are hidden, are showing.
refer the attached file
Amazing, this is just what I need. Thank you Naveed Raza.
Just one thing, is it possible to get the opposite reaction? Now the rows are hidden when boxes are checked. I would love to have the rows unhidden when checked.
Last edited by mixer; 04-05-2014 at 03:30 PM.
I managed to fix it. Thanks again Naveed Raza!!
Glad i could help you out
please make the below things
1. If the suggestion helps you, then Click * to Add Reputation
2. If you are happy with a solution to your problem, mark the thread as [SOLVED] using the tools at the top.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks