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

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, Data Analyst & Excel Lover!

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