Hiding Specific Cells thru Checkbox

[JasonKid1]

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

[:) Sixthsense :)]

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

Sub CheckBox1_Click()
Dim blStatus As Boolean

If CheckBox1_Click Then blStatus = True
Range("C26,C27,D26,D27").EntireRow.Hidden = blStatus
    
End Sub

[JasonKid1]

Would there be a make-shift way to hide individual cells? (ie: bring them forward once a checkbox is clicked). Essentially, is there a way to act like these cells are hidden/unhidden until a checkbox is marked off?

[LJMetzger]

If you format a cell with three semi-colons (custom formatting option), the contents of the cell is hidden from view.

Lewis