Ms Excel VBA

The UK's most regular instructor-led training courses.
Training information: visual+basic+for+excel+courses+london · Microsoft+excel+training · Microsoft Excel Training London
See also · excel-courses-london · excel courses in london · excel microsoft training

Resolved · Low Priority · Version 2003

Ms Excel VBA

Krishan has attended:
MOS/MCAS exam course
Excel Intermediate course
Excel Advanced course
Excel VBA course

by - delegate Krishan [2 posts] (2008 Apr 11 Fri, 16:05) Reply

What is an object?

Version	Date	Location	Places available	Book	Next place rate:
Excel VBA 2 day course
Version	Date	Location	Places available	Book	Card	Invoice
2003/XP	2008 Jul 17 Thu + 18 Fri	Bloomsbury	3	book now	£475	£495
2003/XP	2008 Jul 30 Wed + 31 Thu	Bayswater	5	book now	£450	£485
2003/XP	2008 Aug 7 Thu + 8 Fri	Bloomsbury	6	book now	£450	£485
2003/XP	2008 Aug 14 Thu + 15 Fri	Bloomsbury	5	book now	£450	£485
2003/XP	2008 Aug 26 Tue + 27 Wed	Bayswater	6	book now	£450	£485
2003/XP	2008 Sep 8 Mon + 9 Tue	Bayswater	7	book now	£345	£399
Full Schedule: See all 48 Excel VBA course dates. Bookings currently available until 26th November 2009.

RE: Ms Excel VBA

by - trainer Carlos gold contributer [360 posts] (2008 Apr 14 Mon, 16:38) Reply

Hi Krishan

An object has both properties and methods and can belong to a collection.

As the world around us is made up of physical objects, Excel and other applications are also made up of objects.

In Excel the application is an object and is made up of other objects eg. Workbooks

A Workbook is made up of among other things Worksheets and Charts. So it can be said that a collection of worksheets make up part of a workbook

A worksheet is made up of cells, rows columns.

And the list goes on

Hope this helps

Carlos

· Excel Macros for the Non-Programmer
· Microsoft Excel Cheat Sheet: Tips and Shortcuts
· Tools From Advanced Excel Courses: Goal Seek and Solver
· Customized Financial Excel Courses in London
· What's Better Than the Help Function in Excel? Microsoft Training

Please browse our web site to find out more about
visual+basic+for+excel+courses+london and other Microsoft training courses.

Excel tip:

Do a fast scroll

In big Excel databases with many records, you can move down thousands of rows super-fast as follows: hold down Shift then click on the scrollbar somewhere below the scrollbar handle. This will move you way down the sheet without your having to use the scrollbar up/down arrows or drag on the scrollbar handle.

View all Excel hints and tips