Show All

Add an ActiveX control

1. Open the worksheet where you want to add an ActiveX control.
2. Display the Control Toolbox: point to Toolbars on the View menu, and then click Control Toolbox.
3. Click the control you want to add.
4. Click on the worksheet at the location where you want to place the control.
5. Drag the control to the size you want.
6. If you're adding a check box, text box, command button, option button, list box, combo box, toggle button, or label, enter the text you want to appear on the control.

   How?

   1. Right-click the control.
   2. Point to the name of the object on the shortcut menu (for example, CheckBox Object).
   3. Click Edit.
   4. Edit and type the text.
   5. When you're finished, press ESC.

7. Set the properties you want for the control: right-click the control, and then click Properties on the shortcut menu.

   For information about the properties, press F1 in the Properties dialog box to display the Microsoft Visual Basic Help for Microsoft Forms.

8. Do one of the following:

   Add Visual Basic macro code for a control to be used in Excel

   1. Right-click the control, and then click View Code on the shortcut menu.

   2. In the Visual Basic Editor, write your macro code.

      For information about writing macro code, see Visual Basic Help.

   3. To quit, click Close and Return to Microsoft Excel on the File menu.

   Add a Web script for a control to be used on a Web page

   1. Click the worksheet anywhere within the data that will go on the Web page.

   2. On the Tools menu, point to Macro, and then click Microsoft Script Editor.

   3. In the Script Editor, write your script, using the control ID to handle events for the control.

      For information about developing Web scripts, click the option you want on the Help menu in the Script Editor window.

   4. To return to Excel from the Script Editor, click Exit on the File menu.

9. To quit design mode and enable the ActiveX control, click Exit Design Mode .