Add object libraries to your Visual Basic project

You can select another application's objects that you want available in your code by setting a reference to that application's object library.

Add an object

From the Developer tab, open a Visual Basic project window. See Make the Developer tab visible below if it's not open.

  1. On the Tools menu, click References.

    Preferences selection on Tools menu

  2. Under Available References, select the check box for the object library that you want available in your Visual Basic project.

    Available references dialog

    Note: You should clear the check box for the object libraries that you do not want in your Visual Basic project to reduce the time it takes to compile.

  3. To set the order in which the object libraries are accessed, under Available References, select the object library, and then click the Priority buttons to move the object library up or down.

  4. To add other object libraries to Available References, click Browse, and then find the object library that you want.

  5. Browse for an object

  1. On the top bar, select Excel > Preferences > Ribbon & Toolbar.

  2. Under Customize the Ribbon, select Main Tabs and then check Developer.

  3. Click Save and then close Excel Preferences.

Expand your Office skills
Explore training
Get new features first
Join Office Insiders

Was this information helpful?

Thank you for your feedback!

Thank you for your feedback! It sounds like it might be helpful to connect you to one of our Office support agents.