Microsoft Office Tutorials and References
In Depth Information
The Forms Toolbar
cHoosing BETWEEn forMs conTrols And AcTiVEx conTrols
The primary differences between the two kinds of controls are in formatting and
events. You use Forms controls when you need simple interaction with VBA, such
as running a macro by clicking a button. They are also a good choice when you
don’t need VBA at all, but you want an Option Button or Check Box on your
sheet that will be linked to a cell. If you need to color your control, or format its
font type, or trigger a procedure based on mouse movement or keyboard activity,
ActiveX controls are better.
Be aware that ActiveX controls have a well-deserved reputation for being buggy
and not behaving as reliably as do Forms controls. Forms controls will give you
minimal problems, if any, but they are limited in what they can do. As you
experiment and work with each type, you’ll decide which kind of control works best for
The forms Toolbar
The easiest way to access Forms controls is
through the Forms toolbar. How you get to
the Forms toolbar depends on your version of
Excel. For versions prior to Excel 2007, from
the worksheet menu, click View ➪ Toolbars ➪
Forms, as shown in Figure 13-1.
The Forms toolbar is like any other toolbar that
you can dock at the top or sides of the window,
or have floating on the window above the
worksheet. Figure 13-2 shows the Forms toolbar and
its control icons.
If you are using Excel version 2007 or 2010, the
Forms and ActiveX controls are found by clicking
the Insert icon on the Developer tab of the Ribbon,
as shown in Figure 13-3.
The Developer tab is a very useful item to place on your Ribbon. See the section
entitled “Accessing the VBA Environment” in Lesson 2 for the steps to display
the Developer tab.