Solved

Excel- Difference between Command Button (Active X Control) and Button (Form Control)

Posted on 2011-03-15
4
1,508 Views
Last Modified: 2012-05-11

I'm working on a few macros in Excel and am using a button to execute them.  Can anyone tell me the difference between using a Command Button (Active X Control) and a Button (Form Control)?
0
Comment
Question by:BBlu
  • 2
  • 2
4 Comments
 
LVL 11

Accepted Solution

by:
jkpieterse earned 125 total points
ID: 35145835
The forms buttons are simpler to use and more reliable. The ActiveX one has more formatting options. Also, the click event of a forms button can be any macro located in a normal module, an ActiveX button requires its click event to be in the worksheets module (or in a class module).
It is easy to tie multiple forms buttons to the same macro, you just assign them all to the same. With activex buttons, either each button has its own click event, or you need to write a class module and tie an instance of the class to all buttons.
0
 

Author Comment

by:BBlu
ID: 35151998

Thank you, jkpieterse, for the thorough explanation.  I assume it's safe to say that, when possible, it's better to use form buttons.  Would you say that is true?
0
 
LVL 11

Expert Comment

by:jkpieterse
ID: 35153982
I would, yes. Others may have different opinions!
0
 

Author Closing Comment

by:BBlu
ID: 35249965
Thanks, again.
0

Featured Post

Courses: Start Training Online With Pros, Today

Brush up on the basics or master the advanced techniques required to earn essential industry certifications, with Courses. Enroll in a course and start learning today. Training topics range from Android App Dev to the Xen Virtualization Platform.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This article will guide you to convert a grid from a picture into Excel format using Microsoft OneNote and no other 3rd party application.
Do you use a spreadsheet like Microsoft's Excel?  Have you ever wanted to link out to a non excel file on your computer or network drive?  This is the way I found to do it!
This Micro Tutorial demonstrates using Microsoft Excel pivot tables, how to reverse engineer competitors' marketing strategies through backlinks.
This Micro Tutorial will demonstrate in Microsoft Excel how to add style and sexy appeal to horizontal bar charts.

776 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