This page teaches you how to create a simple loan calculator in Excel VBA. The worksheet contains the following ActiveX controls: two scrollbars and two option buttons. Note: the instructions below do not teach you how to format the worksheet. We assume that you know how to change font types, insert rows and columns, add […]
A spin button can be used to increment a number in a cell. To create a spin button in Excel VBA, execute the following steps. 1. On the Developer tab, click Insert. 2. In the ActiveX Controls group, click Spin Button. 3. Drag a spin button on your worksheet. 4. Right click the spin button […]
If you have more than one option button, only one of the option buttons can be selected. To create option buttons in Excel VBA, execute the following steps. 1. On the Developer tab, click Insert. 2. In the ActiveX Controls group, click Option Button. 3. Drag two option buttons on your worksheet. 4. Right click […]
A check box is a field which can be checked to store information. To create a check box in Excel VBA, execute the following steps. 1. On the Developer tab, click Insert. 2. In the ActiveX Controls group, click Check Box. 3. Drag a check box on your worksheet. 4. Right click the check box […]
A combo box is a drop-down list from where a user can select an item or fill in his/her own choice. To create a combo box in Excel VBA, execute the following steps. 1. On the Developer tab, click Insert. 2. In the ActiveX Controls group, click Combo Box. 3. Drag a combo box on […]
A list box is a list from where a user can select an item. To create a list box in Excel VBA, execute the following steps. 1. On the Developer tab, click Insert. 2. In the ActiveX Controls group, click List Box. 3. Drag a list box on your worksheet. Note: you can change the […]
A text box is an empty field where a user can fill in a piece of text. To create a text box in Excel VBA, execute the following steps. 1. On the Developer tab, click Insert. 2. In the ActiveX Controls group, click Text Box. 3. Drag a command button and a text box on […]
