You can use a Form control button or a command button (an ActiveX control) to run a macro that performs an action when a user clicks it. Both these buttons are also known as a push button, which can be set up to automate the printing of a worksheet, filtering data, or calculating numbers.

Microsoft Excel provides several controls for dialog sheets that are useful for selecting items from a list. Examples of controls are list boxes, combo boxes, spin buttons, and scroll bars. For more information about form controls in Excel, see Overview of forms, form controls, and ActiveX controls on a worksheet. More Information

Create, edit, format, lock, and unlock Excel forms, including data forms, worksheets that contain Form and ActiveX controls, and VBA UserForms.

You can create a form in Excel by adding content controls, such as buttons, check boxes, list boxes, and combo boxes to a workbook. Other people can use Excel to fill out the form and then print it if they choose to.

Add a list box to your Excel worksheet from which users can choose a value. Make data entry easier by letting users choose a value from a combo box. A combo box combines a text box with a list box to create a drop-down list. You can add a Form Control or …

To add an image, click the Build button next to the Picture property box, and then use the Load Picture dialog box to locate and open an image. For detailed information about each property, select the property, and then press F1 to display a Visual Basic Help topic.

You can insert form controls such as check boxes or option buttons to make data entry easier. Check boxes work well for forms with multiple options. Option buttons are better when your user has just one choice. To add either a check box or an …

Add a spin button (Form control) On the Developer tab, in the Controls group, select Insert , and then under Form Controls , select Spin Button . Click the worksheet location where you want the upper-left corner of the spin button to appear.

To add an image, click the Build button next to the Picture property box, and then use the Load Picture dialog box to locate and open an image. For detailed information about each property, select the property, and then press F1 to display a Visual Basic Help topic.

You can insert form controls like check boxes, option, or toggle buttons to make data entry easier. Check boxes work well for forms with multiple options. Option buttons are better when your user has just one choice.