Microsoft 365
Formerly Office 365, is a line of subscription services offered by Microsoft which adds to and includes the Microsoft Office product line.
5,770 questions
Need to hide columns in a different sheet when a checkbox is checked.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(67.2, 54%, 16%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EPN%3C/text%3E%3C/svg%3E)
Pavan Narreddy
0
Reputation points
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 shoul happend for all possible scenarios. Please help me.
Thank you in Advance
Pavan
Sign in to answer