Using The Object Browser

% Lo liminating the need to remember required syntax, the Object Browser enables you to quickly search for an object, property, or method that matches a desired keyword. For example, to add a new worksheet when you do not remember the appropriate method, you can use the search option on the Object Browser to find all objects that deal with the Add method.

The Object Browser refers to each object as a class and lists them within the Classes list box. The Object Browser lists all properties and methods associated with an object selected in the Classes list box within the Members list box. You view the associated properties and methods of an object by selecting the object. The Members list box also shows which VBA functions you can use to return the selected object.

The Object Browser has six different object libraries, which you can use to view object information: Excel, MSForms, Office, Stdole, VBA, and VBA project. You can view all information by selecting the All Libraries option, or you can select an individual object library.

The Excel object library contains all of the objects, methods, and properties in the Excel Object Model. These are the objects discussed throughout this book.

Select the MSForms object library to view objects that you can use to create custom dialog boxes for your macros.

The Office object library contains objects that are common to all Microsoft Office products.

Select the Stdole object library to find objects that you can use for OLE automation.

The VBA object library contains specific Visual Basic for Applications objects.

Each open workbook and the corresponding modules are listed as available objects under VBAProject.

USING THE OBJECT BROWSER

VBAPi

Module 1 Mot

Alphabetic | I Mo du

View | Insert Format Debug □ Code F7

m Object Shift+F7

lit ion Shift+F2

Position Ctrl+5hlft+F2

SONAL.XLS - Module 1 (Code)

P Immediate Wind«

IT! Locals Window

Jp Watch Window fo, Call Stack...

Project Explorer

I Tab Order Toolbars

Tools Add-Ins

I Calculate Expenses

ActiveCell.For Hange ("B3 :H3") Select ion. Nuirib id Sub aï-iLJ

OPEN THE OBJECT BROWSER

D Open the Code window for the desired module.

Was this article helpful?

+4 -2

Responses

  • kaari
    How to use object browser in programming?
    8 years ago
  • fre-qalsi abrha
    How to search in object browser vba?
    1 year ago
  • nicoletta toscani
    How to open object browser in vba?
    9 months ago
  • Kristin Bar
    How do I find Range in object browser?
    8 months ago
  • petros semhar
    How do i use the object browser in excel vba to view how to use an object?
    8 months ago
  • Ulrich Fuchs
    How to keep object browser on screen while programming vba?
    7 months ago
  • tom saarij
    How to read object browser in vba?
    6 months ago
  • Eyob
    How to ouse object browser?
    6 months ago
  • jonne
    How do you go to object borwser in visual basics to connect reference?
    5 months ago
  • ROBERT
    What good is the object browser visual basic?
    5 months ago
  • michelle
    What are some objects yo can browse in the selective browser option in microsoft excel?
    1 month ago
  • simon gebre
    Do i need vba installed to access the object browser?
    1 month ago
  • Mike
    How to start object browser?
    4 days ago

Post a comment