Excel 2010 VBA - Form Controls vs. ACTIVEX Controls

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
brothertruffle880Asked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

wabashbdwCommented:
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.
0
StephenJRCommented:
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).
0
nutschCommented:
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
0
SickSkilzCommented:
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/
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Excel

From novice to tech pro — start learning today.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.