Excel 2016 All-in-One For Dummies
Book image
Explore Book Buy On Amazon

To help your user understand the purpose of your custom functions, you can add descriptions that appear in Insert Function and Function Arguments dialog boxes that help explain what the function does. To add this kind of description to your user-defined function, you use the Object Browser, a special window in the Visual Basic Editor that enables you to get information about particular objects available to the project that you have open.

To add a description for your user-defined function, follow these steps:

  1. Open the Visual Basic Editor from Excel by clicking the Visual Basic button on the Developer tab of the Ribbon or pressing Alt+LV or Alt+F11.

    Now, you need to open the Object Browser.

  2. Choose View→Object Browser from the Visual Basic Editor menu bar or press F2.

    This action opens the Object Browser window, which obscures the Code window.

  3. Click the drop-down list box that currently contains the value and then select VBAProject from the drop-down list.

    When you select VBAProject from this drop-down list, the Object Browser then displays your user-defined function as one of the objects in one of the Classes in the pane on the left.

  4. Right-click the name of your user-defined function.

    This action selects the function and displays it in the Members pane on the right, while at the same time displaying the object’s shortcut menu.

  5. Click Properties on the shortcut menu.

    This action opens the Member Options dialog box for your user-defined function, where you can enter your description of this function.

  6. Type the text that you want to appear in the Insert Function and Function Arguments dialog box for the user-defined function in the Description text box and then click OK.

    Now, you can close the Object Browser and save your changes.

  7. Click the Close Window button to close the Object Browser and then choose the File→Save command.

About This Article

This article is from the book:

About the book author:

Greg Harvey, PhD, is the president of Mind Over Media, LLC., and a bestselling author of books on Excel, including all editions of Excel For Dummies and Excel Workbook For Dummies. He began teaching business users about computers back in the 1980s, and has been a dedicated educator ever since.

This article can be found in the category: