How to Describe a Custom Excel 2013 Function

To help your user understand the purpose of your custom functions in Excel 2013, 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 <All Libraries> 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.

You can now use your function in a formula just as you would a built-in function.

   
blog comments powered by Disqus
Advertisement

Inside Dummies.com