Userform with checkbox(es)

Userforms help the user to input data in a more intuitive manner. The checkbox control can enhance the utility of the userform by providing a single mouse click entry of data. You can, of course, use a single or multiple checkboxes depending on the design of your Excel application. In our example we have used a checkbox for the 'hra' or 'house rent allowance'. You could use another checkbox control to define another parameter like 'medical allowance' with the relevant code for its calculations. You can attach code to the checkbox for more calculations. In this training video we have also shown how to retain the data in the form to compare with the transferred data on the worksheet. Later, in the same video we have added code to 'clear' the controls of the data to make way for a new entry. This makes data entry easier and quicker.