Difference between form controls and activeXcontrol - excel 2007

Posted on 2011-04-30
Last Modified: 2012-05-11
Can any one please tell me the difference between the form control and activeXcontrol?
What the preference/usage?
To me most of the controls are same - but I m new :)
For example there is complete different way of assigning macros/handling buttons - I wonder why?

Can any please explain :)
thanks alot
Question by:SameerMirza
    LVL 81

    Accepted Solution

    ActiveX controls are not compatible with Macintosh Office.
    Mutiple ActiveX controls cannot (easily) be assigned to a single macro.
    Forms contols do not have as many properties as ActiveX controls.
    ActiveX controls tend to cause more problems (workbook corruption).
    ActiveX controls don't always behave as expected (font size changes without prompting, not reset when desired, unusable at times).


    Author Comment

    ok thanks
    But I have seen that activexcontrols are used more often  - or atleast the work I have seen
    I am just thinking that there is more to it.

    Can you use both together on same sheet? - i guess yes
    But how do I distinguish between controls by looking at sheet?
    LVL 81

    Assisted Solution

    by:zorvek (Kevin Jones)
    >Can you use both together on same sheet?


    >But how do I distinguish between controls by looking at sheet?

    It's not easy. One way is how the Properties are accessed. To access the properties of a Forms control right-click on the control and choose "Format Control". The properties are displayed on multiple tabs. The tab containing the properties discussed below is the Control tab. To access the properties of an ActiveX control right-click on the control and choose Properties. Note that the right-click menu will not be displayed unless Excel is in design mode.

    Personally, I do not use ActiveX controls at all. They are too risky and have caused problems for me in the past.


    Author Closing Comment


    Featured Post

    Do You Know the 4 Main Threat Actor Types?

    Do you know the main threat actor types? Most attackers fall into one of four categories, each with their own favored tactics, techniques, and procedures.

    Join & Write a Comment

    Sparklines have been introduced with Excel 2010 and are a useful tool for creating small in-cell charts, used for example in dashboards. Excel 2010 offers three different types of Sparklines: Line, Column and Win/Loss. What it does not offer is a…
    Drop Down List with Unique/Distinct Values (Part II - ComboBox or ListBox and Data Validation List Bonus!) David Miller (dlmille) Intro This article focuses on delivering unique, sorted lists to list objects (e.g., ComboBox, ListBox) and Dat…
    Viewers will learn the basics of slicers and timelines for both PivotTables and standard Excel tables in Excel 2013.
    This Micro Tutorial demonstrate the bugs in Microsoft Excel for Mac with Pivot Charts.

    754 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    21 Experts available now in Live!

    Get 1:1 Help Now