FAQ About Excel Visual Basic for Applications
What is the difference between Form Controls and ActiveX Controls on the Developer tab?
Form Controls are built into Excel, while ActiveX Controls are installed separately.
For example, one of the simple differences can be explained through the List Box.
When a List Box is created with Form Controls, it takes the index value of those values in the cell where the values in the List Box will go. However, when a List Box is created with ActiveX Controls, these values appear directly in the cell.
