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