Excel VBA | Macros for beginners| Learn to Write an Excel Macro from scratch!

Description

Learn step by step how to automate your spreadsheets using the power of programming in Excel! 

This course is designed to teach beginners who have no background in programming how to program in Excel VBA!

What you need before taking this course

• The will to learn!
• You need to be at least an intermediate user of Excel, know how to write formulas, draw charts and use pivot tables.

A Powerful Skill at Your Fingertips

Learning how to program in Excel will increase your market value and allow you to save time on your spreadsheets.

It will also be a great way to tap into the world of programming, and will help lay the foundation in case you need to learn any other programming language!

Who is the target audience?

• Someone who wants to learn how to program/write code in Excel using the Visual Basic for Applications (VBA) language.
• Needs to know how to write formulas, use pivot tables and draw charts in Excel.

• Course Introduction
• Please Follow me
• Recording Macros vs Writing VBA Code
• Understanding Objects in ExcelVBA
• Understanding the VBA Syntax and Parts of Speech
• Activating the Developer Tab
• Recording a basic Macro
• Absolute vs Relative mode in Recording
• Introduction to the Visual Basic Environment
• The Project Explorer
• The Properties Window
• The Code Window
• Immediate, Locals and Watch Windows
• Dealing with Modules
• Writing Comments in Excel VBA
• Introduction and Changing Cell Values
• Adding a text to a cell
• Dealing with Named Ranges
• Value vs Text Property
• Row and Column properties
• The Select Method
• The Count Property
• The Address Property
• The Formula Property
• The Number Format Property
• The Font Property
• Introducing the Cells object!
• Using the Cells collection to affect cells positionally within a range
• Affecting all cells within a sheet
• Combining Range and cells objects
• Selecting Sheets
• Adding Sheets
• Sheets vs Worksheets
• Copying Sheets
• Moving Sheets
• Deleting Sheets
• Introduction to Variables
• Variable Data Types
• Declaring Variables
• Forcing Variable declaration
• Object Variables
• Calling a procedure from another and variable scope
• Public and Private variables
• Declaring Constants
• Referring to Workbooks-Different ways
• Closing Workbooks
• Adding and Saving Workbooks Part 1 - Save method
• Adding and Saving Workbooks Part 2 - Save as method
• Opening Workbooks
• Finding the last row
• Finding the Last Column
• Finding the Next Row
• The With Statement
• Comparison Operators in Excel VBA
• IF Statements- Simple IF Statements
• IF THEN ELSE Structure
• IF THEN ELSEIF Structure
• Nested IFs
• OR /AND logical operators
• NOT Logical Operator
• CASE Statements Part 1 - Single Case Statements
• CASE Statements Part 2 - Nested Case Statements
• GOTO and Labels
• Loops Introduction
• For Next loop
• Exit for Statement
• FOR EACH Loop - Intro
• FOR EACH Loops - More examples
• Do Loop Introduction
• Do Loop Simple Example
• Do until
• Do While
• Do while vs Do until - Movies Example
• Exit Do Statement
• Do Loop Exercise
• The Message Box - Introduction
• Message Box - Inputs
• The Message Box - Capturing the User's Input
• Adding a new line
• Messagebox Exercise
• The Inputbox - introduction
• Inputbox - Example1 - Capturing a user's name
• Inputbox -Employee Database Example Part 1
• Inputbox -Employee Database Example Part 2
• Inputbox Exercise
• Introduction to Error Handling
• Different error types in action
• On Error Statement Resume Next
• On Error GoTo Statement
• Resetting the error handling Status with On Error Goto 0
• The Err Object
• Setting a Breakpoint
• Worksheet Events - Worksheet Selection Change
• Worksheet Events - Worksheet Activate event
• Worksheet Events - Worksheet Deactivate event
• Worksheet events - Worksheet Before delete event
• Worksheet Events - Worksheet Before Double Click Event
• Worksheet events - Worksheet Before Right Click
• Worksheet Events - Calculate Event
• Worksheet Events- Enabling and Disabling events
• Worksheet Events - Worksheet Change event
• Worksheet Events - Follow Hyperlink Event
• Worksheet events Exercise
• Workbook Events - Workbook Open Event
• Workbook Events - Workbook Activate event
• Workbook Events - Workbook BeforeSave event
• Workbook Events - Workbook AfterSave event
• Workbook Events - Workbook Before Close event
• Workbook Events - Workbook Before print event
• Workbook Events - Workbook De-activate event
• Workbook Events - Workbook New Chart event
• Workbook Events - Workbook New sheet event
• Workbook Events - Workbook sheet calculate event
• Workbook Events - Sheet Deactivate Event
• Workbook Events - Workbook Follow Hyperlink Event
• Workbook Events - Workbook Window Activate event
• Workbook Events - Workbook Window De-activate Event
• Workbook Events - Workbook Window Resize Event
• Workbook Events Exercise
• Thanks for Watching