top of page
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
bottom of page