Excel VBA Coding / Programming for Tasks Automation (Beginner to Intermediate)

 

Course Plan:

• Advantages and Uses of VBA

• Developing Tab

• Recording Macros

• Visual Basic Editor interface

• Object Oriented Programming

• Workbook, Worksheet, Range, Cell objects

• With statement

• Procedure: Sub and Function

• Variables and Data Types

• Using MsgBox and InputBox

• Select Case statement

• Condition Logic (IF statement)

• Iteration (For....Next, Do….Loop statements)

• Arrays

• Events

• Debugging