Excel VBA hide the form control buttons

Question

I have created an "Expandable/Collapsible" structure using VBA. I have added some form controls, like a dropdown or option buttons in each of the section, but the issue is that, when the whole thing is collapsed, the form controls are visible in the button. please check the screenshot and advise a solution.

Siddharth Rout · Accepted Answer · 2021-02-24 05:16:37Z

3

Yes that is because you have not selected Move and Size with cells.

That option is greyed out when you right click on the control and then click on Format Controls | Properties | Move and Size with cells for Option Button and Combo Box as shown below.

You need to use a different way to activate it.

Click the control and then click as shown below

And then from there you can set those properties.

Now those controls will hide when you collapse the rows.

answered Feb 24, 2021 at 5:16

Siddharth Rout

150k18 gold badges212 silver badges258 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Excel VBA hide the form control buttons

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related