Excel 2010 VBA - Form Controls vs. ACTIVEX Controls

brothertruffle880
brothertruffle880 used Ask the Experts™
on
As you can see from the illustration, there are form controls and ActiveX controls.  Some are identical.  
Command Button
Check Box
Combo Box
List Box
Option Button
Spin Button

Why would a person use an ACTIVEX control versus regular form control (let's say a list box)?

controls.jpg
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
There are other experts on here who know a LOT more about the differences than I do, but I use ActiveX controls when I don't want to hassle with creating a form to house the control.  For instance, I often place ActiveX drop down boxes inside a cell to allow the user to select which data to view.  I could do the same thing with a form but it would take a little more time and trouble.
You get a lot more code options with ActiveX controls. Have a look and see - there are many more events whereas Form controls have only the change event (I think).
Top Expert 2008

Commented:
As mentioned above, the Active X controls provide much deeper control over actions and behaviors. However, they're not always the most stable. A couple of times, I've had to shift from Active X to Forms, as the controls were behaving erratically (changing formats on their own etc)

Thomas
I would recommend only using the forms controls.  The activeX versions do have some more options but can be less stable.

Here is a site that explains it very well.
http://peltiertech.com/WordPress/forms-controls-and-activex-controls-in-excel/

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial