A list box is appropriate when you want to limit input to what is on the list.ĥ. User can set up multiple columns as well. By default, the choices are displayed vertically in a single column. With list boxes, user can select an item from the list. List Box:A list box control shows a list of items from which the user can select one or more at the same time. User can select one or more than one options at the same time.Ĥ. Generally, Check Box is used to show a Yes/No or True/False selection to the user. Check Box:The check box control displays a check mark when it is selected. Combo box will take less space as full list is not displayed until the user clicks the down arrow.ģ.

A combo box contains an edit field options that are not in the list can be manually entered. Combo box is appropriate when there is a list of options. You can add items to the list of your choice & create drop down lists by using the ComboBox control.This control allows the user to select an item either by typing text into the combo box or by selecting it from the list. Combo Box:Combo Box control is used to display a drop-down list of items. You can assign a command button to automate the macro or some calculation of formulas.Ģ. 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.

Microsoft internet controls excel