Need help: Check box that hides columns in sheet2

[atflick]

I've been searching and trying different things, but I keep running into errors. Basically I just need some VB code that will use a checkbox on sheet1 that when checked will show columns F:H on sheet 2, and when unchecked they will be hidden.

(I rarely use macros/VB so I apologize if this is super easy)

Thanks!

[walruseggman]

Change CheckBox21 to whatever your check box is named.

Please Login or Register  to view this content.

[atflick]

I get an error "subscript out of range" on line: Set ws2 = Worksheets("Sheet2")

[walruseggman]

Do you have a sheet named "Sheet2" in that workbook? Change "Sheet2" to whatever the sheet name is of the sheet you want the columns hidden on.

[atflick]

Now it says Object Required on this line If CheckBox1.Value = True Then ... I'm pretty sure the check box is named CheckBox1

[walruseggman]

Well that is the exact error I would expect if the checkbox wasn't named CheckBox1. Please verify the name by Entering Design Mode on the Developer tab, selecting the checkbox, right click --> Properties and look what is in the (Name) field.

One other thought. I used an ActiveX checkbox, I don't believe a Form Control Checkbox will work with VBA, so make sure you're using ActiveX.

[atflick]

What do I need for ActiveX, it doesn't look like I have that. Is it an add-on or something that's hidden from me at the moment?

[walruseggman]

ActiveX controls should be installed by default. See screenshot. You'd want the lower checkbox, under the ActiveX controls label.

Edit: You can also see the check box name there on the left of the screen.

AX.png

[atflick]

OK yep, I'm an idiot. However it says I cannot insert... Searching it seems some update broke ActiveX controls and I need to delete some files. Does that mean anyone else who uses this file would also need to delete some files to use the checkboxes?

[walruseggman]

Ha, oh yeah, that was a huge error by Microsoft, and AFAIK they have yet to fix it, but they are aware of it.

I don't believe it means anyone who uses that file would need to delete those files; it only has to do with inserting ActiveX controls, not using them, I think.

[atflick]

Woohoo, got it to work now. Thank you so much!