Need to Hide Columns in a sheet2 , when multiple check-boxes are ticked in sheet1

[pavanreddy]

Team,

I am new to excel VBA coding, Could you please help me in this.

My requirement is, In sheet1, I have a multiple check-box, with values IBM, HPM,UNY,ASM, When I tick check-box IBM, the columns with names HPM,UNY,ASM in Sheet2 has to be hidden and only IBM Column has to be visible.

Similarly when I tick multiple check-boxes, example, IBM and HPM, Columns UNY,ASM are to be hidden and only IBM and HPM columns are to be visible in sheet2 and this should happen for all possible scenarios. Please help me.

Thank you in Advance

Pavan

 

[Micron]

Perhaps you can adapt this code.

Macro to hide columns by Header Names

Hi, I am looking to hide columns by header names. The columns I would like to hide are "name", "date" and "age". Thanks!

www.mrexcel.com

The problem I see with using checkboxes is that a user can have more than one checked so IMO they are not practical for this. Better to use option buttons. That way, only one can be checked at a time.