To locate and insert a procedure using the Object BrowserIf you forget the names of your arguments or would like to paste them in rather than type them, you can use the Object Browser. The Object Browser lists all the Sub procedures and Function procedures in all currently open workbooks, including hidden workbooks.
To locate and insert a procedure using the Object Browser
1. On the View menu, click Object Browser.
2. In the Libraries/Workbooks box, click the name of a workbook.
3. In the Objects/Modules box, click the name of the module, and then click the name of the procedure in the Methods/Properties box.
4. To view the code for a procedure, click Show.
This is the easiest way to view the code for a function without actually opening the module that contains it. (You can view and execute procedures from the Macro dialog box, but not functions. The Macro dialog box lists only Sub procedures with no optional arguments. It doesn't list Sub procedures with optional arguments or any Function procedures.)
5. To paste the procedure into your code, click Paste.
It may help you remember details about a procedure if you enter a description that will appear at the bottom of the Object Browser dialog box when you click that procedure.
To enter a procedure description
1. With a procedure selected in the Object Browser, click Options.
2. In the Macro Options dialog box, type a description in the Description box.