To group different controls here, we first need to have Radio control which is customized.Ĩ. Right-click on it and select Format Control as shown below. This only allows us to group other controls under it. Group Box – This is used for multi controls. Now, if we select this option box, reference cell A2 will be seen with a value of 1. Now in the window below, select the Cell Link. Right-click on this and select Format Object. Select and draw this anywhere in the worksheet. Option Button – This is used when we need to select one option among others. And the number will be seen in Cell Link B1.Ħ. We can navigate to up and down and select and number. We will see, in the List box, all the numbers from the input range are seen. Here we have selected the range input range of numbers 1 to 5. Then in the window of Format Control, select the Input range and Cell link. Right-click on any List menu and select Format Control. Select the option and draw anywhere in the sheet. List Box – List Box can contain any range of list values. We can then click on the Up and Down arrow to navigate the from values from 1 to 12.ĥ. Now under the Control tab, give the limit as per requirement and select cell link as well. Spin Button – As the name says, we can spinning around the selected values by this. When we check the CheckBox with a tick mark, we will get TRUE at the selected cell. Select type and cell link as shown below. Right-click on the box and select Format Controls. Just by a single click on it, we will see a Tick inside the box. Please select this option from Form Control and draw it. CheckBox – This is used when we just need to mark an option for status. Once done, click on the drop-down arrow, we will be able to see all the selected values. Here it is from A1:A5 with drop down lines as 5. To assign value to the Combo Box drop-down, click right on it and select Format Control. Combo box – To use Combo Box, select the option and draw anywhere in the sheet. To assign a macro to this button, right-click and select Assign Macro.Ģ. We can edit the name of the button as well, just by putting the cursor on it.
0 kommentar(er)
