Whereas when using normal shapes, the macro is written first and then it is simply selected in the dialog box when assigning the macro. With ActiveX command buttons, the macro you want to link to the button is written after the button is created.

ActiveX Controls can be used as objects in codesĪs soon as you click View Code in the Developer tab, or right-click the ActiveX command button in Design Mode and select View Code, Excel creates a macro that is linked to the button.ActiveX Controls can be used on UserForms and not only in worksheets.ActiveX Controls have extensive properties settings that you can use to customize their appearance, behaviour, fonts, and other characteristics.ActiveX Controls allow for flexible design requirements.And there are a few advantages to using ActiveX Controls rather than basic Forms Control. The ActiveX command button is the most widely used ActiveX Control. Location for ActiveX Controls (Developer tab, Instetr drop-down menu) From the Insert command, you can choose either a Form control or an ActiveX Control as shown in the image below. Examples of ActiveX Controls are buttons, check boxes, text boxes, and list boxes.ĪctiveX Controls can be found in the Controls group on the Developer Tab, under the Insert command. For example, these fields can be personalized for the kind of input required or the number of characters an input field can contain. If you are working on a VBA model in Excel, and you want to make it look even smoother, you can link your macros to ActiveX command buttons.ĪctiveX Controls allow you to create not only clickable buttons, but also to create fields for user input.

Activex controls in excel vba