ActiveX Controls are the one of the most frequently used Controls while automating any application with VBA. We use different ActiveX Controls in Excel Wiorksheet or UserForm and perform various operations or tasks in Excel Workbook Application. ActiveX Controls are CheckBox, Label, Image, TextBox, ComboBox, ListBox, CommandButton, OptionButton, and we have some controls.

Excel VBA ActiveX Control

We have different Controls to deal with Excel VBA ActiveX Controls. Here you can find brief explanation about each Control and their use explained more detailed way. And also find example codes for better understanding. You can develop any Excel VBA application by using ActiveX Controls on the UserForm. You can use these Controls On the Worksheet to develop dashboards.

Excel VBA ActiveX Controls:

  • CheckBox: CheckBox Control is used to specify or indicate binary choice. That is either Turn on or off a value. When we use more checkboxs, you can select more than one CheckBox at a time on the Worksheet or on the UserForm.Please find more information about ActiveX CheckBox Control by clicking on the following link.
  • Read More …

  • ComboBox: ComboBox ActiveX Control is used to store and display list of items to a list. ComboBox can be used on the WorkSheet or UserForm. Please find more information about ActiveX ComboBox Control by clicking on the following link.
  • Read More …

  • CommandButton: CommandButton is used to run or execute a macro or procedure. It performs a task or an action when a user clicks on a command button. Command Button can be used on the WorkSheet or UserForm. Please find more information about ActiveX CommandButton Control by clicking on the following link.
  • Read More …

  • Image: Image control embeds a picture such as a jpg, jpeg, gif, png, bitmap, etc. It can be used on the WorkSheet or UserForm. Please find more information about ActiveX Image Control by clicking on the following link.
  • Read More …

  • Label: Label is used to display descriptive text or information or instructions. It can be title, caption, etc. It can be used on the WorkSheet or UserForm. Please find more information about ActiveX Image Control by clicking on the following link.
  • Read More …

  • ListBox: ListBox ActiveX Control is used to display list of items to a list. ListBox can be used on the WorkSheet or UserForm. Please find more information about ActiveX ListBox Control by clicking on the following link.
  • Read More …

  • OptionButton: Option Button is used to select only one selection from multiple selections within a group. When we select an OptionButton on the user form in a group immediately it will de select all other OptionButtons in the same group. OptionButton has value property. Please find more information about ActiveX OptionButton Control by clicking on the following link.
  • Read More …

  • TextBox: TextBox is used to display data, edit data, etc in the rectangular box. The Textbox can be linked to a Worksheet Cell. The TextBox can have static and dynamic value. Please find more information about ActiveX TextBox Control by clicking on the following link.
  • Read More …

Premium Project Management Templates

120+ Professional Project Management Templates!

A Powerful & Multi-purpose Templates for project management. Now seamlessly manage your projects, tasks, meetings, presentations, teams, customers, stakeholders and time. This page describes all the amazing new features and options that come with our premium templates.

PREMIUM TEMPLATES
LIMITED TIME OFFER
ON SALE80% OFF
BROWSE ALL TEMPLATES

Advanced Project Planning Templates

Excel Templates

VIEW DETAILS

120+ Project Management Templates Pack

Excel | PowerPoint | Word

VIEW DETAILS

ULTIMATE RESOURCE MANAGEMENT TEMPLATE

Excel Template

VIEW DETAILS

50+ Essential Project Management Templates

Excel | PowerPoint | Word

VIEW DETAILS

Project Portfolio Management Templates

Excel | PowerPoint Templates

VIEW DETAILS

50+ Excel Project Management Templates

Excel Templates

VIEW DETAILS

Share This Story, Choose Your Platform!

2 Comments

  1. MS office 365 support October 8, 2018 at 12:30 PM

    ActiveX controls. ActiveX controls can be utilized on worksheet frames, with or without the use of VBA code, and on VBA UserForms. As a rule, using ActiveX controls when you require more adaptable outline necessities than those given by Form controls.

  2. Saju December 5, 2018 at 1:06 PM

    I need to set filter to same column with different values one after other. Is it possible.

Leave A Comment