|
To help your user understand the purpose of your custom VBA Excel functions, you can add descriptions that appear in the Insert Function and Function Arguments dialog boxes. To add a description to your user-defined VBA function, follow these steps: Open the Visual Basic Editor by choosing Tools, Macro, Visual Basic Editor or by pressing Alt+F11. Choose View, Object Browser from the Visual Basic Editor menu bar. The Object browser window opens. Click the drop-down list that currently contains the value All Libraries and select VBAProject on the drop-down list. The Object Browser displays your user-defined function as one of the objects in one of the Classes in the pane on the left. Right-click the name of your 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. Choose Properties on the shortcut menu. This action opens the Members Options dialog box for your user-defined function, where you can enter your description of the function. Type the text that you want to appear in the Insert Function and Function Arguments dialog boxes and then click OK. Close the Object Browser and save your changes.
|
