The Forms controls have been part of Excel for longer (I'm thinking Excel 4)
than the Controls Toolbox (Excel 97), so it stands to reason that they'd be
more seamlessly integrated. Being newer, the ActiveX controls have richer
formatting possibilities. Both can link to cells and ranges in the
worksheet. Some advanced users have attributed buggy behavior to the ActiveX
controls from the Controls Toolbox.

The Forms controls can be have macros assigned to them. The ActiveX controls
have event procedures that run when they are clicked; these procedures are
either inserted in the code modules of the objects (i.e., worksheets) they
are embedded in, or written in class modules.

Forms controls can be used on chart sheets, ActiveX controls cannot. ActiveX
controls do not work in MacExcel.

Excel responds to a Forms control after the user finishes interacting with
it (i.e., unclicks). Excel responds continuously to an ActiveX control. For
example, suppose a scrollbar is linked to a cell's value. If the control is
a Forms slider, the user has to slide the bar on the control, then release
it before the cell updates. If the control is an ActiveX Scrollbar, the cell
updates continuously as the user slides the bar along the control.

In general I use the Forms controls, unless I need the continuous response
of an ActiveX scrollbar.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. - http://PeltierTech.com
_______


"funGT350" wrote in message
...
What is the difference Between a Forms Control versus an Active-X Control?
(e.g. a Combo Box from the Forms Toolbar versus a Combo Box from the
Control
Toolbox Toolbar?) Why would one use one versus the other?