Hi,

Looking for some help with showing some columns that are hidden from view and viewable when using a check box.

I am using the following VBA:

Sub DisplayTypes_Checkbox()
Range("C:D").EntireColumn.Hidden = Range("A1").Value
End Sub

This does work and completes the job, but it displays a tick in the checkbox when they are hidden, but I want it to be blank and only ticked when they are displayed.

Is there a way to reverse is so the checkbox is blank if the columns are hidden?

Thanks.