Hiding Specific Cells thru Checkbox

Good afternoon,

I am relatively new to coding things on Excel (it's been a solid 5 years since I've last coded anything - I have basic knowledge but, in essence, I know nothing).

I'm looking to see if it's possible for me to leave information in specific cells hidden unless a checkbox is marked off. I do not need/want the entire column or row hidden (which I've found plenty of tutorials on via google)

I'll try to provide a basic example:

ie: Column A1: checkbox;;;Column B1: Dairy;;;Column C1: milk;;;Column D1: slim milk
Column A2: checkbox;;;Column B2: Poultry;;;Column C2: beef;;;Column D2: hamburgers;;;Column E2: bubba burgers (<--not a fan of them)

(the values in row C and D will never change - there are some instances where there are values in column E)

I need the checkboxes in column A and the information in column B visible at all times but C and D (and E) visible only if the checkbox is checked.

Here is an example code I tried creating myself (with the help of the .entirerow.hidden and .entirecolumn.hidden codes I found online). Obviously it didn't work lol, but I was wondering if there is a way to only get these specific cells to hide rather than an entire row/column.

Sub CheckBox1_Click()

If CheckBox1_Click = True Then

Range(C26, C27, D26, D27).Cells.Hidden = False

Else

Range(C26, C27, D26, D27).Cells.Hidden = True

End If

End Sub

Thank you for the assistance!
Jason

You cannot hide any specific cell in excel, either you have to hide the Entire Column Or Row...

Please Login or Register  to view this content.