Maxsol T.

VBA Macro Classes/Advance Excel (all India Online & Classroom at Pune)



Duration: 5 to 6 weekends

Timing: Sat & Sun (1 to 2 hrs)




Note: this course is only for working professionals.



Introduction to Visual Basic Editor 2010

Understanding Excel Objects

Workbook, Worksheet

Variables,

Variable declaration and data-types in VBA (any version).

Properties

Methods

Events

Range Object

Range Object Properties

Range Object Methods

Using conditional statement [IF] to work on Range data

Using loops to manipulate data in Range

Working with Collections

Advantages of using collections

Scenarios: To understand the use of collections

Sub versus Function

Programming Formulas into Worksheet Cells

Using Worksheet Functions

A1 Reference

R1C1 Reference

Handling VBA Error / Debug VBA code