Optionbuttons and userforms

If you have to choose from many options and then perform calculations in your Excel worksheet, then you can use option buttons in your userforms. As we mentioned earlier, userforms provide a great interface to enter data. Because you have labels next to the controls where you enter data, data entry in userforms is quick and easy. In our example, employees have the option of receiving a house rent allowance or a renovation allowance, if they live in their own house. Selecting one of the optionbuttons triggers a calculation with the correct data once you hit the command button. The training video gives the accurate details in action.