Find a Procedure

Microsoft VBA

Find a Procedure

   

To find a procedure in the Code window

  • To view an existing general procedure, select (General) in the Object box in the Code window, and then select the procedure in the Procedure box.

  • To view an event procedure, select the appropriate object in the Object box in the Code window, and then select the event in the Procedure box.

    Note   To visually separate procedures in the Code window, you can select the Procedure Separator check box on the Editor tab of the Options dialog box (Tools menu). You can switch between Procedure view and Full Module view using the buttons in the lower-left corner of the Code window.

To find a procedure in another module

  1. On the View menu, click Object Browser, or press F2.

  2. Select the project in the Project/Library box.

  3. Select the module in the Classes list.

  4. Double-click the procedure name in the Members of list.

    The selected procedure is displayed in the Code window.

You can use the following keyboard shortcuts:

Press To
CTRL+DOWN ARROW Display the next procedure.
CTRL+UP ARROW Display the previous procedure.
PAGE DOWN Page down through the procedures in your code.
PAGE UP Page up through the procedures in your code.
F2 Display the Object Browser.