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

Abdelrahman Abdou, Data Analyst & Excel Lover!

Play Speed
  • 0.5x
  • 1x (Normal)
  • 1.25x
  • 1.5x
  • 2x
121 Lessons (9h 4m)
    • 1. Promo Video

      0:57
    • 2. Please Follow me

      0:17
    • 3. Introduction

      3:29
    • 4. Recording Macros vs Writing VBA Code

      3:49
    • 5. Understanding Objects in ExcelVBA

      7:18
    • 6. Understanding the VBA Syntax and Parts of Speech

      9:48
    • 7. Activating the Developer Tab

      0:55
    • 8. Recording a basic Macro

      5:04
    • 9. Absolute vs Relative mode in Recording

      3:56
    • 10. Introduction to the Visual Basic Environment

      2:09
    • 11. The Project Explorer

      2:05
    • 12. The Properties Window

      2:17
    • 13. The Code Window

      4:18
    • 14. Immediate,Locals and Watch Window

      3:48
    • 15. Dealing with Modules

      3:08
    • 16. Writing Comments in Excel VBA

      0:59
    • 17. Introduction and Changing Cell Values

      10:27
    • 18. Adding a text to a cell

      1:27
    • 19. Dealing with Named Ranges

      3:15
    • 20. Value vs Text Property

      3:37
    • 21. Row and Column properties

      2:02
    • 22. The Select Method

      2:12
    • 23. The Count Property

      3:37
    • 24. The Address Property

      9:23
    • 25. The Formula Property

      3:27
    • 26. The Number Format Property

      6:34
    • 27. The Font Property

      8:14
    • 28. Introducing the Cells object!

      5:55
    • 29. Using the Cells collection to affect cells positionally within a range

      5:08
    • 30. Affecting all cells within a sheet

      2:20
    • 31. Combining Range and cells objects

      2:33
    • 32. Selecting Sheets

      5:48
    • 33. Adding Sheets

      11:07
    • 34. Sheets vs Worksheets

      3:54
    • 35. Copying Sheets

      5:15
    • 36. Moving Sheets

      1:16
    • 37. Deleting Sheets

      3:32
    • 38. Introduction to Variables

      6:22
    • 39. Variable Data Types

      9:27
    • 40. Declaring Variables

      14:06
    • 41. Forcing Variable declaration

      4:56
    • 42. Object Variables

      8:28
    • 43. Calling a procedure from another and variable scope

      3:15
    • 44. Public and Private variables

      7:14
    • 45. Declaring Constants

      4:03
    • 46. Referring to Workbooks-Different ways

      3:45
    • 47. Closing Workbooks

      3:17
    • 48. Adding and Saving Workbooks Part 1 - Save method

      4:03
    • 49. Adding and Saving Workbooks Part 2 - Save as method

      10:26
    • 50. Opening Workbooks

      6:18
    • 51. Finding the last row

      8:58
    • 52. Finding the Last Column

      3:39
    • 53. Finding the Next Row

      4:24
    • 54. The With Statement

      3:52
    • 55. Comparison Operators in Excel VBA

      0:59
    • 56. IF Statements- Simple IF Statements

      6:43
    • 57. IF THEN ELSE Structure

      3:21
    • 58. IF THEN ELSEIF Structure

      6:42
    • 59. Nested IFs

      4:21
    • 60. OR /AND logical operators

      7:08
    • 61. NOT Logical Operator

      2:49
    • 62. CASE Statements Part 1 - Single Case Statements

      8:49
    • 63. CASE Statements Part 2 - Nested Case Statements

      6:22
    • 64. GOTO and Labels

      2:44
    • 65. Loops Introduction

      1:26
    • 66. For Next loop

      10:55
    • 67. Exit for Statement

      8:36
    • 68. FOR EACH Loop - Intro

      6:42
    • 69. FOR EACH Loops - More examples

      4:48
    • 70. Do Loop Introduction

      3:49
    • 71. Do Loop Simple Example

      1:27
    • 72. Do until

      1:50
    • 73. Do While

      1:44
    • 74. Do while vs Do until - Movies Example

      3:47
    • 75. Exit Do Statement

      4:57
    • 76. Do Loop Exercise

      0:46
    • 77. The Message Box - Introduction

      3:14
    • 78. Message Box - Inputs

      7:22
    • 79. The Message Box - Capturing the User's Input

      4:30
    • 80. Adding a new line

      2:00
    • 81. Messagebox Exercise

      2:10
    • 82. The Inputbox - introduction

      3:38
    • 83. Inputbox - Example1 - Capturing a user's name

      5:18
    • 84. Inputbox -Employee Database Example Part 1

      5:19
    • 85. Inputbox -Employee Database Example Part 2

      3:59
    • 86. Inputbox Exercise

      1:44
    • 87. Introduction to Error Handling

      9:04
    • 88. Different error types in action

      3:48
    • 89. On Error Statement Resume Next

      2:26
    • 90. On Error GoTo Statement

      4:25
    • 91. Resetting the error handling Status with On Error Goto 0

      4:38
    • 92. The Err Object

      7:18
    • 93. Setting a Breakpoint

      1:57
    • 94. Worksheet Events - Worksheet Selection Change

      8:01
    • 95. Worksheet Events - Worksheet Activate event

      3:16
    • 96. Worksheet Events - Worksheet Deactivate event

      2:11
    • 97. Worksheet events - Worksheet Before delete event

      1:31
    • 98. Worksheet Events - Worksheet Before Double Click Event

      7:55
    • 99. Worksheet events - Worksheet Before Right Click

      2:54
    • 100. Worksheet Events - Calculate Event

      3:03
    • 101. Worksheet Events- Enabling and Disabling events

      2:50
    • 102. Worksheet Events - Worksheet Change event

      11:04
    • 103. Worksheet Events - Follow Hyperlink Event

      2:41
    • 104. Worksheet events Exercise

      1:01
    • 105. Workbook Events - Workbook Open Event

      4:46
    • 106. Workbook Events - Workbook Activate event

      2:06
    • 107. Workbook Events - Workbook BeforeSave event

      6:09
    • 108. Workbook Events - Workbook AfterSave event

      3:49
    • 109. Workbook Events - Workbook Before Close event

      8:50
    • 110. Workbook Events - Workbook Before print event

      2:37
    • 111. Workbook Events - Workbook De-activate event

      1:59
    • 112. Workbook Events - Workbook New Chart event

      7:47
    • 113. Workbook Events - Workbook New sheet event

      2:33
    • 114. Workbook Events - Workbook sheet calculate event

      3:24
    • 115. Workbook Events - Sheet Deactivate Event

      5:38
    • 116. Workbook Events - Workbook Follow Hyperlink Event

      2:02
    • 117. Workbook Events - Workbook Window Activate event

      5:37
    • 118. Workbook Events - Workbook Window De-activate Event

      1:35
    • 119. Workbook Events - Workbook Window Resize Event

      1:29
    • 120. Workbook Events Exercise

      1:09
    • 121. Thanks for Watching

      0:18
12 students are watching this class

About This Class

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.