excel 2003 visual basic intermediate course - list objects

Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

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 /

resolvedResolved · Low Priority · Version Standard

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 ?

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

 

Training information:

Welcome. Please choose your application (eg. Excel) and then post your question.

Our Microsoft Qualified trainers will then respond within 24 hours (working days).

Frequently Asked Questions
What does 'Resolved' mean?

Any suggestions, questions or comments? Please post in the Improve the forum thread.


 

Excel tip:

Using Alt in Save Dialog Box

When you are saving (or opening) a file, try these;
(Note the numbers are on the keyboard not the numeric keypad)
1. Go to previous folder Alt+1
2. Go up one folder level Alt+2
3. Search the Web Alt+3
4. Delete selected file Alt+4 or Delete
5. Create a new folder Alt+5
6. Cycle through all views Alt+6 repeatedly
7. Display the Tools menu Alt+7

View all Excel hints and tips


Server loaded in 0.13 secs.