Right-click the group box control and choose Grouping → Group. Select the group box control and then hold Ctrl while selecting each of the other controls that you want to group. Option buttons and checkboxes can be bound together (so only one option at a time can be selected from the group) by placing them in a shared Group Box. The default name for the ActiveX control is Option Button 1.Ī good way to distinguish them is by opening the control's Properties list (on the ribbon under the Development tab, or by right-clicking the control and choosing Properties, or hitting F4), because the ActiveX control has many more options that the simpler form control. The default name for the form control is OptionButton1. In Excel, the two types of radio buttons are actually called Option Buttons. How-To Geek : What ActiveX Controls Are and Why They’re Dangerous The following figure demonstrates this interaction: This container type, called a control container or control object, can operate an ActiveX control by using the control’s properties and methods, and receives notifications from the ActiveX control in the form of events.
#ACTIVEX MICROSOFT EXCEL 2011 FULL#
Note that the full functionality of an ActiveX control is available only when used within an OLE container designed to be aware of ActiveX controls. When you add an ActiveX control to an application, it becomes part of the development and run-time environment and provides new functionality for your application.Īn ActiveX control is implemented as an in-process server (typically a small object) that can be used in any OLE container. You use ActiveX controls just as you would any of the standard built-in controls, such as the CheckBox control. : Overview of forms, Form controls, and ActiveX controls on a worksheetĪbout ActiveX controls and related Security ConcernsĪn ActiveX control is an extension to the VBA Toolbox. : Why are form-related commands or controls on the ribbon disabled? Other factors may affect control availability. This image below shows which common controls are generally available for use in Worksheets and User Forms.
Controls created programmatically do not have (or require) a default name and therefore should have one assigned immediately upon creation. ☆ "Default name" applies to controls created manually. In Excel, we have a " Form Control Combo Box", and an " ActiveX Control Combo Box": In some programming languages, comparable controls are referred to as a "drop-down menu" or "drop-down list". (List here.)įor example, let's compare the two types of Combo Boxes. The two look, behave, and are controlled similarly, but not identically. Think of the word "form" as being used in a general sense: While this is technically correct, don't let this confuse you. Office documentation also occasionally refers to a worksheet as a form. This is nothing more than a userform made specifically for data entry/manipulation of data, so it would've made more sense to call them (the more familiar sounding) "Data Entry Userform". Some sites discuss also discuss a Data Form.
There are two types of controls: Form controls and ActiveX controls:īoth types of controls can be used on worksheets but only ActiveX controls can be used on userforms.įorm controls are part of the Shapes collection (just like Drawing Objects), and thus are referred to like:ĪctiveX controls are basically part of the worksheet and are therefore referred to like:īoth types of controls can be created, modified and deleted from either the worksheet, or programmatically with VBA, however, the 2 types of controls have slightly varying syntax when using VBA to refer to them.
(Adapted from my original post here - now closed)
#ACTIVEX MICROSOFT EXCEL 2011 CODE#
This is only a general overview of the differences between Form Controls and ActiveX Controls (based on my old notes that helped me finally figure out the differences!) Visit the included links for more detailed information about each control including code and sample projects. There is confusion surrounding the two types of controls available to Excel - exacerbated by the contrasting terminology used by different online sources.