THE COURSE IS BEST FIT FOR AN INDIVIDUAL WHO IS ASPIRING TO BECOME MASTER IN EXCEL VBA PROGRAMMING.
Excel VBA and Macro training is designed for them who are the expert user of MS-Excel having the comprehensive knowledge about functions, features and formulae and would like to enhance their knowledge to the next level by automating their repetitive tasks or designing the new functions, add-ins, Dash Boards with drop-down menus and many more.
Utilising Intrinsic Functions
Variables and Expressions: Defining expressions and statements How to declare variables Determining data types Programming with variable scope Harnessing intrinsic functions Defining constants and using intrinsic constants Adding message boxes and using input boxes How to declare and use object variables
Managing Program Execution: Defining control-of-flow structures Using boolean expressions Working with the if...end if decision structures Working with the select case...end select structure Working with the do...loop structure Working with the for...next structure Working with the for each...next structure Restrictions for use of control-of-flow structures
Harnessing Forms and Controls: Defining UserForms Utilising the toolbox Using UserForm properties, events and methods Understanding controls Setting control properties in the properties window Using the label control Using the text box control Using the command button control Using the combo box control Using the frame control Using option button controls Using control appearance Determining the tab order Filling a control Increasing code to controls How to launch a form in code Using the PivotTable Object Defining PivotTables Making a PivotTable Using the PivotTable wizard method Using PivotFields Adding a procedure to a custom toolbar
Debugging The Code: Defining errors Working with debugging tools Determining breakpoints How to step through code Working with break mode during run mode Identifying the value of expressions
Handling Errors: Defining error handling Defining VBA’‘s error trapping options Capturing errors with the on error statement Determining the error object Coding an error handling routine Using inline error handling Further Excel Object Model The Range object The Current Region object Workbooks and worksheets collections Chart object List object
Arrays: Dynamic arrays Array optimisation Multidimensional arrays Arrays and objects
Object Oriented Programming (OOP): Classes and objects creating new objects creating new classes Error handling
Good programming techniques: Recursive programming Using optional arguments Best Practice for Excel Programming
Introduction: Introducing Visual Basic for Applications Defining the development environment Using help Closing the VB editor
Developing with Procedures and Functions: Understanding and creating modules Defining procedures Creating a sub-procedure Calling procedures Utilising the immediate window to call procedures Making and naming a function procedure Working using the code editor
Further Object Orientated
Programming: Destroying objects Default property and method working with collections Advanced Procedures, parameters, variables Passing parameters by reference and by value Optional and default parameters Passing an array of arguments to a procedure Using enumerations User-defined Type Implicit and explicit conversions
Linking with Office: Connecting to other Office applications Working with other Office applications
Importing from Access using ADO Understanding Active-X data objects The Connection string Manipulating data
Macro Security: How macro security works Digitally signing macros
Knowledge of any Programming Language.
Jyotsna Nitin Binjwe
Has a teaching & working experience of 10+ years. She has also handled many software development projects