VBA Macro’s Course - Contents
Module 1
VBA Macro’s Course
What Is Vba & How Vba Works With Excel
- Quick Review of Macros
- Introducing the Visual Basic Editor
- Uses of record Macros
- Understanding and creating modules
Programming Concepts
- VBA Sub and Function Procedures
- How to create a message box
- Write a Program to update and retrieve information using Input Box
- Understanding and using Select Case statement
- How do I define a variables and Rules for defining a Variables Name and Type
- Creating And using Variables
- Working with range Objects
- How to save and Protect Modules
DECISION MAKERS
- If……Then……Else
- If……Then……ElseIf……If
Other Kinds of Loops
- Working with Do While u. Loop Procedure
- Do…… Until Loop and Do…… Loop Until
- Do……While loop and Do…… Loop While
- For each…… Next
- For……Next
Workbook Obects Create or Add Single and Multiple Workbooks
- Workbook Save and Save AS
- Open Single and Multiple Workbooks
- Close Specify and Multiple Workbooks
- Activate From one workbook to another Workbook
- Open Workbook from Specific Path
- Get Workbook Name and Paths
- Hide and Unhide for Single and Multiple Workbooks
- Protect and Unprotect Worksheets
Worksheet Objects insert a single and Multiple Worksheets
- Delete Specific and multiple worksheets
- Get Count of Worksheets
- Select a Specific and all Worksheets
- Get All Worksheets Name
- Hide and Unhide For Single and Multiple Worksheets
- Rename for Single and Multiple Worksheets
- Protect and unprotect worksheets
- Sort and Move worksheets
- Calculate entire worksheet
- Using VBA and worksheet Function
Cell objects insert Single and multiple Row , Column and Cells
- Delete Single and Multiple row, Column and Cells
- Get Range or Address of Cell and Selection
- Navigate from one Cell to another Cell
- Select specific Range, Cell, Rows and Column
- Types of Selection and Offset method
- Insert Function In cell
Reading and Writing Arrays
- Defining Arrays
- Arrays as Outputs
- Arrays as inputs
- The Arrays as a Collection
- The Array as an Array
Form Controls and User Forms (Create and Design an user Form)
- Working With User Forms & User Forms Events Like List Box, Combo Box, Option Buttons, Check Box, Text Box, Labels, Command Button, Toggle Button.
- How To Create Dynamic Dashboard On User Form With Different Controls
- How To Link Various User Form With Each Other To Create A Complete Interface Between
User And System
