![form controls vs activex controls in excel form controls vs activex controls in excel](https://wmfexcel.files.wordpress.com/2014/12/excel-tips-activex-control-not-working.png)
Form controls are the original controls that are compatible with earlier versions of Excel, starting with Excel version 5.0.Supports macros which is scoped to public in VBA.You also cannot assign a macro to run directly from an ActiveX control the same way you can from a Form control. ActiveX controls cannot be added to chart sheets or XLM macro sheets.You can also control different events that occur when an ActiveX control is interacted with.ActiveX controls have extensive properties that you can use to customize their behavior setting various properties.
Form controls vs activex controls in excel code#
In general, use ActiveX controls when you want to perform design with less code but if you need more flexible design than use Form controls.
![form controls vs activex controls in excel form controls vs activex controls in excel](https://www.exceldemy.com/wp-content/uploads/2014/02/setting-linked-cells-in-properties-window.png)
If the shortcut menu contains the command Edit Text, the object is a Drawing Tools object.įor a Form control, click the control and make sure that the control border is displayed. If the shortcut menu contains the command Properties, the control is an ActiveX control, and Excel is in Design mode. Tip: To display the correct shortcut menu for a group box Form control, make sure that you select the perimeter of the group box, and not the interior of the group box. If the shortcut menu contains the command Assign Macro, the control is a Form control. To determine the type of control you are working with, right-click the control, and then note the following: Because there are three different types of controls and objects that you can modify uniquely, you may not know for sure which type of control it is just by looking at it. Many controls are positioned close to each other.įirst, determine the type of control that you want to select. If Excel is not in Design mode, when you try to select an ActiveX control, you might unintentionally start an action, such as running a macro or selecting a check box. Causeīecause a Form control can contain text or other objects (such as an image), when you try to select the control, you might not be selecting the entire control if you do not position the pointer precisely on the control border.
![form controls vs activex controls in excel form controls vs activex controls in excel](https://access-excel.tips/wp-content/uploads/2014/12/feature_excel-e1496498521642.png)
Selecting a control is sometimes difficult and unpredictable. Excel for Microsoft 365 Excel 2021 Excel 2019 Excel 2016 Excel 2013 Excel 2010 More.