VBA is the programming language of Microsoft. It helps in doing tedious and complex office task. It helps in creating a spreadsheet and for calculating a large amount of data. We all know Microsoft excel is the basic tool which is commonly used for a personal and professional purpose.

VBA Tutorial

Part 1

• Navigate through the Excel Workbook Environment
• Understand order of operations
• Define cell names and use built-in functions in Excel
• Use relative and absolute references in Excel
• Plot data sets in Excel

Part 2

• Access the VBA environment and create macros
• Pass data between the VBA and Excel workbook environments
• Communicate with users using InputBox and MsgBox
• Use absolute and relative referencing in VBA
• Store and utilize data using variables

Part 3

• Understand and use data types (Double, Integer, String, Boolean)
• Create constants
• Use VBA's built-in functions

Part 4

• Create your own Sub procedures in VBA
• Understand variable scope and variable lifetime
• Pass data by value and by reference between Sub procedures

Part 5

• Create your own Function procedures in VBA and invoke them
• Understand the difference between Sub and Function procedures
• Create customized worksheet functions
• Use procedures within procedures

Part 6

• Utilize relational and logical operators
• Use If-Then, If-Then-Else, If-Then-ElseIf, and Select Case structures
• Create flowcharts to visually explain how your program utilizes selective execution

Part 7

• Use For loops, Do While loops, and Do Until loops
• Create flowcharts to visually explain how your program performs repetitive execution

Part 8

Part 9

• Create 1D and 2D arrays and use them to store data
• Pass arrays to Sub procedures and Function procedures