Hiding Check Boxes In VB excel 2007.

**Starrysky** · 12-09-2008, 03:49 PM

Hello!!

Im Having trouble with my Visual basic code in Excel 2007.
I'm using the code to hide two rows which works fine, however my code to hide the check box (second line of code) doesn't work so if anyone can see where I'm going wrong that would be great

Please Login or Register  to view this content.

**davesexcel** · 12-10-2008, 01:34 AM

Perhaps this will work

Please Login or Register  to view this content.

**Starrysky** · 12-10-2008, 12:15 PM

Thanks for trying to help but that code still doesn't work and needs to be debuged like my previous one :S

**ChemistB** · 12-10-2008, 12:34 PM

Weird, DavesExcel's code does not give me an error but the checkbox becomes ghostlike (I can still see it but can no longer click on it and can now click on the cells behind it. What error are you getting when you run the code?

Note: Control Toolbox Checkboxes do not have spaces (Checkbox1) and Forms Checkboxes do (Check box 1)

**Starrysky** · 12-10-2008, 01:15 PM

Well It was givng me errors but i tried your previous suggestion of putting spaces between then Check box as it is a form control box and now it does work but at the wrong time. It now disappears when the other check box isn't checked and then hides the rows at the right time when check box 17, and I need both the rows and check box hidden at the same time??

**ChemistB** · 12-10-2008, 02:06 PM

This code will hide the rows and the checkbox when your first checkbox is checked and will unhide them when it is not checked.

Please Login or Register  to view this content.

Does that work for you?

**Starrysky** · 12-10-2008, 02:37 PM

No

Please Login or Register  to view this content.

The above needs to be debugged run-time error 424

**ChemistB** · 12-10-2008, 03:44 PM

Hmmm, I don't have Excel 2007 so the problem might be there. Here is my workbook. Download and see if it gives you problems.

**Starrysky** · 12-10-2008, 04:25 PM

The problem was I was using two form control option buttons it now works yays! thank you! Do you know a way to cell link control option buttons I've never used them before??

**ChemistB** · 12-10-2008, 04:34 PM

With the control Toolbox in the edit mode (the engineering triangle button depressed on the toolbar), right click on your checkbox and choose properties. One of the properties is "Linked Cell" Input the cell ID. Okay?

**Starrysky** · 12-10-2008, 05:50 PM

Found properties and my workbook is all finished now with the hidden rows and checkbox working perfectly! Thank you sooo much you've been such a help yays so happy it's all finsihed hehe!!