hiding columns with a checkbox

[Schotzz]

I am having a little trouble hiding columns using a checkbox. What I am trying to do is when the checkbox is checked it will hide several columns and when it is un-checked it will un-hide them. Is there an easy way to do this?

Thanks for any help or advice!

 

[sunnyland]

Hello try this replace the n:n,c:c,e:e by the letters of your columns

Private Sub CheckBox1_Click()
If CheckBox1.Value = True Then
Range("n:n,c:c,e:e").Select
Selection.Columns.Hidden = True
Else
Range("n:n,c:c,e:e").Select
Selection.Columns.Hidden = False
End If
End Sub