Create a macro for an ActiveX control

Microsoft Office Excel 2003

previous page next page
  • Display the Control Toolbox: point to Toolbars on the View menu, and then click Control Toolbox.
  • Click Design Mode Button image.
  • Right-click the control, and then click View Code on the shortcut menu.
  • In the Visual Basic Editor, write a new macro or change the existing macro.
  • When you finish writing the macro, click Close and Return to Microsoft Excel on the File menu.
  • When you finish designing the control, click Exit Design Mode Button image.

    • ShowTip

    If you're designing a form for use on a Web page rather than in Microsoft Excel or a Visual Basic program, use a Web script instead of a macro to automate the control.

    previous page start next page