Add a custom button that runs a Visual Basic function to a toolbar

  1. Create the function you want the button to run.

    How?

  2. On the View menu, point to Toolbars, and then click Customize.

  3. If it isn't already displayed, show the toolbar you want to add the button to.

    How?

  4. In the Customize dialog box, click the Commands tab.

  5. In the Categories box, click File.

  6. Drag the Custom command from the Commands box to the displayed toolbar.

  7. With the Customize dialog box open, right-click the button on the toolbar, and then on the shortcut menu, type a new name for the button in the Name box.

  8. On the same shortcut menu, click Properties.

  9. In the On Action box, type the name of the function you want to run in the format =functionname(). For example, for a custom function named SetCaption(), type =SetCaption(). For a built-in function, enter the name of the function and any required arguments, for example =MsgBox(IIf(Instr(Time(), "PM"), "Good Afternoon", "Good Morning")).

  10. Specify any other properties for the button.