VBA – ActiveX and Form Control

Spread the love

Form controls and VBA coding provides an excellent UI to an End User.

  • Form controls help to  design the dashboard , data entry form etc.
  • Excel form controls allow to link to a particular cell

Excel Form Controls

Button                        – Trigger a code
Combo Box                – Popup a list for selection and choose a single value from list
Check Box                 – Refer if parameter has to be followed on not
Radio/Option Button  – Offer to select a single option from group of options
List box                      – A list of options to choose (can be set on multiple selections)
Group box                  – Make a group of controls in it
Label                          – Assign a name to a Control
Spin Button                – Up/down option it refer a value to select basis on intervals between min max values
Scroll Bar                   – Scroll from linked cell

VBA Active X

Button                       – Trigger a code
ComboBox                – Popup a list for selection and choose a single value from list
Check Box                – Refer if parameter has to be followed on not
Radio Button             – Offer to select a single option from group of options
List box                     – A list of options to choose (can be set on multiple selection )
Group box                – Make a group of controls in it
Label                        – Assign a name to a Control
Spin Button               – Up/down option it refer a value to select basis on intervals between min max values
Scroll Bar                  – Scroll form