Forum home » Delegate support and help forum » Microsoft Excel VBA Training and help » excel 2003 visual basic intermediate course - List of objects /

excel 2003 visual basic intermediate course - List of objects /

ResolvedVersion Standard

Mon 28 Jan 2008, 11:21 Delegate Jean-francois said...

Jean-francois has attended:
Excel VBA Intro Intermediate course

List of objects /

Where can i find a list of the possible object to be used in VBA ?

Sun 10 Feb 2008, 09:31 Trainer Stephen said...

RE: List of objects /

Hello Jean-Francois

Thank you for your question

If you enter the VBE and press F2 you will open the object browser. In this you can search for selected objects and view the complete list of their methods and properties.

Another approach is to bring up help and search for "microsoft excel object model". This presents you with a diagrammatic description of the object model

Hope this is useful

Regards

Stephen

Training courses

98.7 % recommend us

More live stats...

Training information:

Active questions
Advanced/consultancy questions
Today's questions
Unanswered questions
Popular forum topics

Excel tip:

Importing Numbers in Excel 2010

Occasionally, when importing data into Excel you find that the some of the imported values are treated as text.

To convert these numbers to actual values, click on an empty cell and press Ctrl+C.

Next, select the range that contains the values you need to change and in the Clipboard Group on the Home tab, click the Paste drop-down arrow and choose Paste Special. In the Paste Special dialog box, select Add and then click OK.

View all Excel hints and tips

excel 2003 visual basic intermediate course - List of objects /

List of objects /

RE: List of objects /

Excel articles

Excel tip:

Importing Numbers in Excel 2010