Difference between form controls and activeXcontrol - excel 2007

Hi,
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
SameerMirzaAsked:
Who is Participating?
 
zorvek (Kevin Jones)ConsultantCommented:
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).

Kevin
0
 
SameerMirzaAuthor Commented:
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?
0
 
zorvek (Kevin Jones)ConsultantCommented:
>Can you use both together on same sheet?

Yes.

>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.

Kevin
0
 
SameerMirzaAuthor Commented:
thamks
0
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.

All Courses

From novice to tech pro — start learning today.