• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 306
  • Last Modified:

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
0
SameerMirza
Asked:
SameerMirza
  • 2
  • 2
2 Solutions
 
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

Featured Post

Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

  • 2
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now