bridgenax.blogg.se

Command Button: Command buttons are also referred to as push buttons. Click on Insert & then select ActiveX Control of your choiceġ.

You will find ActiveX Controls under Developer ribbon When a user of the form interacts with the control, VBA code then runs to process any events that occur for that control. You can also write macros that respond to events associated with ActiveX controls. You can perform various actions, depending on the user selection from the list box control, a combo box with items when a user clicks a button. With ActiveX Controls, you can control different events that occur when an ActiveX control is initiated. We can use ActiveX controls to customize their appearance, fonts, behavior and many other characteristics because of their extensive properties. ActiveX controls can be used on worksheet forms, with or without the use of VBA code, and on VBA UserForms.ĪctiveX controls provide more flexible design requirements than those provided by Form controls.