Excel VBA | Macros for beginners| Learn to Write an Excel Macro from scratch! | Abdelrahman Abdou | Skillshare
Browse
All Classes
Student Projects
Sign In
Home
Browse
Student Projects

Playback Speed

  • 0.5x
  • 1x (Normal)
  • 1.25x
  • 1.5x
  • 2x

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

teacher avatar Abdelrahman Abdou, Experienced Excel & Power BI Trainer

Watch this class and thousands more

Get unlimited access to every class
Taught by industry leaders & working professionals
Topics include illustration, design, photography, and more

Watch this class and thousands more

Get unlimited access to every class
Taught by industry leaders & working professionals
Topics include illustration, design, photography, and more

Lessons in This Class

120 Lessons (8h 60m)

    • 1. Course Introduction

      2:07

    • 2. Please Follow me

      0:17

    • 3. Recording Macros vs Writing VBA Code

      3:49

    • 4. Understanding Objects in ExcelVBA

      7:18

    • 5. Understanding the VBA Syntax and Parts of Speech

      9:48

    • 6. Activating the Developer Tab

      0:25

    • 7. Recording a basic Macro

      5:04

    • 8. Absolute vs Relative mode in Recording

      3:56

    • 9. Introduction to the Visual Basic Environment

      2:09

    • 10. The Project Explorer

      2:05

    • 11. The Properties Window

      2:17

    • 12. The Code Window

      4:18

    • 13. Immediate, Locals and Watch Windows

      2:31

    • 14. Dealing with Modules

      3:08

    • 15. Writing Comments in Excel VBA

      0:59

    • 16. Introduction and Changing Cell Values

      10:27

    • 17. Adding a text to a cell

      1:27

    • 18. Dealing with Named Ranges

      3:15

    • 19. Value vs Text Property

      3:37

    • 20. Row and Column properties

      2:02

    • 21. The Select Method

      2:12

    • 22. The Count Property

      3:37

    • 23. The Address Property

      9:23

    • 24. The Formula Property

      3:27

    • 25. The Number Format Property

      6:34

    • 26. The Font Property

      8:14

    • 27. Introducing the Cells object!

      5:55

    • 28. Using the Cells collection to affect cells positionally within a range

      5:08

    • 29. Affecting all cells within a sheet

      2:20

    • 30. Combining Range and cells objects

      2:33

    • 31. Selecting Sheets

      5:48

    • 32. Adding Sheets

      11:07

    • 33. Sheets vs Worksheets

      3:54

    • 34. Copying Sheets

      5:15

    • 35. Moving Sheets

      1:16

    • 36. Deleting Sheets

      3:32

    • 37. Introduction to Variables

      6:22

    • 38. Variable Data Types

      9:27

    • 39. Declaring Variables

      14:06

    • 40. Forcing Variable declaration

      4:56

    • 41. Object Variables

      8:28

    • 42. Calling a procedure from another and variable scope

      3:15

    • 43. Public and Private variables

      7:14

    • 44. Declaring Constants

      4:03

    • 45. Referring to Workbooks-Different ways

      3:45

    • 46. Closing Workbooks

      3:17

    • 47. Adding and Saving Workbooks Part 1 - Save method

      4:03

    • 48. Adding and Saving Workbooks Part 2 - Save as method

      10:26

    • 49. Opening Workbooks

      6:18

    • 50. Finding the last row

      8:58

    • 51. Finding the Last Column

      3:39

    • 52. Finding the Next Row

      4:24

    • 53. The With Statement

      3:52

    • 54. Comparison Operators in Excel VBA

      0:59

    • 55. IF Statements- Simple IF Statements

      6:43

    • 56. IF THEN ELSE Structure

      3:21

    • 57. IF THEN ELSEIF Structure

      6:42

    • 58. Nested IFs

      4:21

    • 59. OR /AND logical operators

      7:08

    • 60. NOT Logical Operator

      2:49

    • 61. CASE Statements Part 1 - Single Case Statements

      8:49

    • 62. CASE Statements Part 2 - Nested Case Statements

      6:22

    • 63. GOTO and Labels

      2:44

    • 64. Loops Introduction

      1:26

    • 65. For Next loop

      10:55

    • 66. Exit for Statement

      8:36

    • 67. FOR EACH Loop - Intro

      6:42

    • 68. FOR EACH Loops - More examples

      4:48

    • 69. Do Loop Introduction

      3:49

    • 70. Do Loop Simple Example

      1:27

    • 71. Do until

      1:50

    • 72. Do While

      1:44

    • 73. Do while vs Do until - Movies Example

      3:47

    • 74. Exit Do Statement

      4:57

    • 75. Do Loop Exercise

      0:46

    • 76. The Message Box - Introduction

      3:14

    • 77. Message Box - Inputs

      7:22

    • 78. The Message Box - Capturing the User's Input

      4:30

    • 79. Adding a new line

      2:00

    • 80. Messagebox Exercise

      2:10

    • 81. The Inputbox - introduction

      3:38

    • 82. Inputbox - Example1 - Capturing a user's name

      5:18

    • 83. Inputbox -Employee Database Example Part 1

      5:19

    • 84. Inputbox -Employee Database Example Part 2

      3:59

    • 85. Inputbox Exercise

      1:44

    • 86. Introduction to Error Handling

      9:04

    • 87. Different error types in action

      3:48

    • 88. On Error Statement Resume Next

      2:26

    • 89. On Error GoTo Statement

      4:25

    • 90. Resetting the error handling Status with On Error Goto 0

      4:38

    • 91. The Err Object

      7:18

    • 92. Setting a Breakpoint

      1:57

    • 93. Worksheet Events - Worksheet Selection Change

      8:01

    • 94. Worksheet Events - Worksheet Activate event

      3:16

    • 95. Worksheet Events - Worksheet Deactivate event

      2:11

    • 96. Worksheet events - Worksheet Before delete event

      1:31

    • 97. Worksheet Events - Worksheet Before Double Click Event

      7:55

    • 98. Worksheet events - Worksheet Before Right Click

      2:54

    • 99. Worksheet Events - Calculate Event

      3:03

    • 100. Worksheet Events- Enabling and Disabling events

      2:50

    • 101. Worksheet Events - Worksheet Change event

      11:04

    • 102. Worksheet Events - Follow Hyperlink Event

      2:41

    • 103. Worksheet events Exercise

      1:01