Form controls part 2

Form controls in Excel are objects that you can add to a worksheet to create interactive forms, questionnaires, or surveys. These controls can be used to input or display data, and to trigger actions based on user input. Some of the most commonly used form controls in Excel include: Check boxes: These are used to give users a simple yes/no or true/false option. Radio buttons: These are used to provide users with a set of mutually exclusive options from which they must choose one. Drop-down lists: These are used to provide users with a list of options from which they can select one. Combo boxes: These are similar to drop-down lists, but they also allow users to type in a custom option. Spin buttons: These are used to increment or decrement a value in a cell by a certain amount. Scroll bars: These are used to provide a visual way for users to adjust a value within a range. Text boxes: These are used to allow users to input text or numerical data. Option buttons: These are similar to radio buttons, but they can be grouped together so that users can select only one option from a group. To insert form controls, go to the Developer tab in the Excel ribbon (if it's not already visible, go to File > Options > Customize Ribbon, and check the Developer box). Then, click on the type of control you want to insert from the Controls group, and draw it onto the worksheet. Once the control is inserted, you can right-click on it to access its properties, and customize its behavior and appearance as needed.