excel 2003 visual basic intermediate course - List of objects /

Resolved · Low Priority · Version 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:

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