Microsoft Excel
Visual Basic

Contact Us
Feed Back Form
E-Mail Us

Tel:
024 7637 2073

To return to the Microsoft Excel Course Index please Click Here

A.K.Solutions: Visual Basic behind Microsoft Excel Course Content
For this 2 day course, no previous knowledge of VBA is required but a good knowledge of Excel is Recommended.  Previous programming experience will help, but again is not essential.  Learn how to enhance Excel with your own VBA procedures and functions.

• The basics

  • Recording and Editing Macros,

  • The Visual Basic Editor, 

  • The Project Explorer, 

  • The ‘Immediate Window’

• Writing your own code:

  • Creating Sub Procedures

  • Calling Procedures

  • Assigning to a Control Key sequence

  • Menu Bar option or Command Button

  • Active X Controls

• Creating your own Functions:

  • Creating User Defined Functions

  • Passing Argument(s)

  • Optional Argument(s)

  • Returning the result of a function

• Calling functions:

  • Using Excel functions within VBA procedures

  • Worksheet Functions available to VBA

  • Understanding what UDFs Cannot Do

• The Object Browser:

  • Discovering Properties

  • Methods and Events using the Object Browser

  • Error Trapping

• Understanding Objects, Collections, Properties:

  • Application object

  • Workbooks collection

  • Workbook object

  • Worksheets collection

  • Range object

  • Range properties

  • Cells property

  • Offset property

  • Resize property

  • Text versus Value property

• And finally:

  • Efficient use of Methods

  • Events

  • Using Worksheet Events

You may print this page by selecting File Print in your Browser Window

Before taking this course.
All candidates are advised to have a good working knowledge of Microsoft Excel

To contact A.K.Solutions:- enquiries@aksolutions.co.uk

E-Mail Us

Contact Us
Feed Back Form

Tel:
024 7637 2073

Copyright © 1994 - 2006 A.K.Solutions. All rights reserved.  Revised: January 13, 2006.