![]() ![]() You can bind each option button in different groups to different cells. ![]() To gather option buttons into multiple groups, you need to combine them under Group Boxes. Enter or select a cell by using Cell link.Īfter binding, click on an option button to see the index of selected option button in the cell.īy default, Excel assumes all option buttons in a worksheet are related with each other.On the other hand, you can bind your option buttons to a cell to retrieve the index value of the selected option. If you only need this control as a visual element, you can start to use your option button right away. Click anywhere to insert a default option button, or hold and drag the cursor to define the size of the option. When you click the Insert button, you will see the same controls under two sections:Ĭlicking the Option Button button changes the cursor into a plus. Once the Developer tab is visible, you can find the Option Button command under the Insert button in the Controls section. You can see detailed steps at How to display the Excel Developer tab for using advanced features.
0 Comments
Leave a Reply. |