The Best Office Productivity Tools Kutools for Excel Solves Most of Your Problems, and Increases Your Productivity by 80% Please change the displayed text of the Radio buttons to Yes/No manually. Then borders of all Group boxes are hidden immediately.

VBA code: Hide border of Group Boxes Sub ToggleVisible()ħ. In the window, click Insert > Module, then copy and paste below VBA code into the Module window. Press the Alt + F11 keys to open the M icrosoft Visual Basic for Applications window. Then you can hide the borders of all Group boxes with below VBA code as you need. After inserting two radio buttons into a Group box, repeat the above step 4 to finish inserting all radio buttons into the Group Boxes. Click Developer > Insert > Option Button (Form Control) to insert a radio button into the Group Box. Repeat the above steps to insert a list of Group Boxes as below screenshot shown.Ĥ. Then insert a Group Box into the worksheet.ģ.

Note: Please display the Developer tab in your Excel if you need.Ģ. Click Developer > Insert > Group Box (Form Control).

Please do as follows to create Yes/No checkboxes in Excel worksheet.ġ. If you need to create a list of Yes/No checkboxes and make them mutually exclusive to each other, a method in this article can help you.Ĭreate Yes/No checkboxes by grouping radio button How to create Yes or No checkboxes in Excel?

Shortcode for checkbox in excel mac