![]() 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 Comments
Leave a Reply. |