Do I have to write a seperate code for each ActiveX checkbox to hide rows?

**Angelammarten** · 11-19-2014, 05:21 PM

I have a very large spreadsheet that has many (100+) ActiveX checkboxes, about half of the those are in control of hiding or un-hiding rows. Below is a string of codes that I have in place currently to make the page functional for my purposes but there is ALOT of code I had to write over and over (or copy and paste) for each ActiveX Control and its affiliated rows.

My question is this: is there a way to have one code for all or do they each need to be done separately as I have done already?

Please Login or Register  to view this content.

You guys are the best!!! THANK YOU

**pjwhitfield** · 11-19-2014, 05:58 PM

More info is needed as to the set up of your sheet but the code below will cycle through all the checkboxes on the sheet.

Please Login or Register  to view this content.

If your checkboxes are numbered sequentially (and say 1-50 control the hiding/unhiding) then hopefully you can calculate the row to be hidden
eg

If checkbox1 hides row 19, 2 hides 20, 3 - 21 etc then

Please Login or Register  to view this content.

**mehmetcik** · 11-19-2014, 06:18 PM

This works.

Wait and I'll give you some better news.

Please Login or Register  to view this content.

**jaslake** · 11-19-2014, 06:28 PM

Hi Angel

Use a Class Module...see this Link...if you have issues implementing let me know.

http://www.bettersolutions.com/excel...A619860332.htm

**Angelammarten** · 11-19-2014, 06:37 PM

So the above would be great if all of my checkboxes and row numbers followed that module however, as luck would have it that pattern doesn't follow through the rest of the sheet.

**jaslake** · 11-19-2014, 06:48 PM

Hi Angel

You really should consider this

Use a Class Module...see this Link...if you have issues implementing let me know.

Please attach a sample file that represents what you have. The structure of your attachment should be the same structure as your actual data. Any proprietary information should be changed.

Include in the attachment any code you're currently using (whether it works or not) and, if appropriate, an "After" worksheet that demonstrates what you wish the output to be.

To Attach a File:

1. Click on Go Advanced
2. In the frame Attach Files you will see the button Manage Attachments
3. Click the button.
4. A new window will open titled Manage Attachments - Excel Forum.
5. Click the "Add Files"... button to locate your file for uploading.
6. This will open a new window File Upload...Click "Select Files"
7. Once you have located the file to upload click the Open button. This window will close.
8. You are now back in the Manage Attachments - Excel Forum window.
9. Click the "Upload Files" button and wait until the file has uploaded.
10. Click the "Done" Button.

**mehmetcik** · 11-19-2014, 06:52 PM

Sorry I had a corrupt file.

Had to recreate it.

Ok in the attached file.

Type 100 into D4 and click on the button.

The macro will create the code for 100 Checkboxes.

Cut column A and paste into visual basic.

Enjoy

**Angelammarten** · 11-19-2014, 09:43 PM

Wow you're amazing! I'll send tomorrow morning when I return to work. Thank you so Oooooh much!

**Angelammarten** · 11-20-2014, 10:15 AM

As promised here is the sheet I am working on with all proprietary info removed. Don't laugh, this was my first try at doing something like this. Thank you again for your help!! I just want the specified rows to be hidden when the boxes are checked and the boxes within those rows to be hidden as well.