Part VI: Automating Excel
FIGURE 45.1
This worksheet uses UserForm controls.
This workbook is available on this book’s website at http://www.wiley.com/go/excel2019bible. The
file is named mortgage loan.xlsx.
Adding controls to a worksheet can be a bit confusing because Excel offers two different
sets of controls, both of which you access by choosing Developer ➪ Controls ➪ Insert:
Form controls These controls are unique to Excel.
ActiveX controls These controls are a subset of those that are available for use on
UserForms.
Figure 45.2 shows the controls that appear when you choose Developer ➪ Controls ➪ Insert.
When you move your mouse pointer over a control, Excel displays a ScreenTip that identi-
fies the control.
To add to the confusion, many controls are available from both sources. For example, a con-
trol named ListBox is listed in both Forms controls and ActiveX controls. However, they’re
two entirely different controls. In general, Forms controls are easier to use, but ActiveX
controls provide more flexibility.
