VBA Macros Programming - Quick Learn Series ( 2 Days)

About The Event
 

VBA (Visual Basic for Applications) is the programming language of Excel and other Office programs. Want to learn much more about VBA programming in Excel? Join our 2 days crash course on VBA macros programming. Learn all the aspect of VBA coding by practicing. Our experts trainer will help you to learn the concepts quickly and also create a mini project at the end of the second half.

 

Topics that will be covered:

 

Introduction to Macros Programming.

Using macro recorder.

Getting Familiar with VBA Editor.

Writing basic code.

VBA syntax to refer an object.

Object Properties & Methods.

Working with cell/range object

Working with cells, sheets and workbooks

VBA code to copy paste.

Objects and Collections

Conditions and Loops

Using IF condition in VBA.

IF-Else and IIF conditions.

Multiple IF vs Select Case

Do While Loop

For-Each & For-Next

Loop between sheets and workbooks.

Functions and Events

Creating formulas with VBA.

Calling functions and procedures.

Using XL Formulas in VBA code.

Passing arguments to functions.

Workbook events.

Sheet Events

Cell Change Events

Charts Pivots and Userforms

Creating dynamic charts with Excel.

Code to create and update Charts.

Creating Pivots with VBA.

Creating User form to gather information.

Design User form.

Working with User form controls.

Creating a responsive User form.

Error Handling Techniques

 

 

Learn the tricks from the experts.