Skip to content
Sabaqاردو

Excel VBA and Macros (Leila Gharani)

By Leila Gharani

Course audio
Course audio: English
Level
Intermediate
Length
15 lessons

What you'll be able to do

  • Find your way around the Visual Basic Editor
  • Write macros that read, write and copy cell ranges
  • Use variables, IF statements and loops in VBA

About this course

Leila Gharani, a well-known Microsoft Excel trainer, teaches Excel VBA through practical, task-based videos. Lessons include copying data between sheets, a tour of the Visual Basic Editor, properties and methods, referring to ranges and writing to cells, copy and paste with VBA, declaring variables, IF THEN with ELSEIF, looping through cells, message boxes, creating workbooks and sheets with arrays, the FIND function, ActiveX combo boxes and checking whether files or folders exist. It suits Excel users who repeat the same tasks and want to automate them. Start by recording a macro, then edit the code.

Before you start: Confident everyday Excel use

Syllabus

Sabaq lists the first 15 videos of this playlist; the rest continue on YouTube. Full playlist on YouTube

  1. 1Excel VBA: Copy Data from one Sheet to Another (Absolute Vs. Relative Macro Recording)
  2. 2Excel VBA tutorial for beginners: The Visual Basic Editor (VBE)
  3. 3Learn How to Use Properties and Methods in Excel VBA Effectively
  4. 4Excel VBA: Referring to Ranges & Writing to Cells (Range, Cells, Offset, Names)
  5. 5Easiest Ways to Copy and Paste Cells with Excel VBA (copy, pastespecial, resize & offset)
  6. 6How to Declare (Dim) and Set VBA Variables (use data types correctly)
  7. 7Excel VBA IF THEN Statement (with ELSEIF & Looping in cells)
  8. 8Loop Through Cells Inside the Used Range with Excel VBA (For Each Collection Loop)
  9. 9How to use the Message Box in Excel VBA (syntax you'll need for msgbox)
  10. 10Create Excel Workbooks Worksheets Automatically with Excel VBA Arrays
  11. 11Excel VBA FIND Function (& how to handle if value NOT found)
  12. 12Excel ActiveX Combo Box to Select Worksheets with VBA
  13. 13How to Insert Cell Values into Footers and Headers in Excel
  14. 14Excel VBA: How to Check if File or Folder Exists (Dir Function)
  15. 15Reset Dependent Drop-down in Excel (with a tiny bit of VBA)

What to take next

Related courses

Videos by Leila Gharani, played from their official YouTube channel. Subscribe on YouTube

Official upload by the teacher or institution on their own channel, shown with YouTube's embedded player.

Sabaq lists the first 15 videos of this playlist; the rest continue on YouTube. Full playlist on YouTube

Lessons last checked Oct 2026. Course summary and lesson structure by Sabaq.

Report a problem or a rights request