Skip to content
UdemyExcelPaid courseBeginner levelCertificate

Excel VBA Macros: Hyper-disambiguated Excel VBA Programming (Udemy.com)

Learn Excel VBA macros, using clean, clear VBA programming techniques and code that you fully understand

Created by: Grant Gamble

Last updated November 2025

icon
What you will learn

  • By the end of this course, you will be confidently writing VBA macros which automate procedures in Microsoft Excel.
  • You will fully understand the purpose and syntax of each line of code that you write.
  • You will not simply be entering lines of code because you have been told they will produce a certain result.
  • You will gain a solid understanding of both the VBA and Excel object models which underly VBA programming.

How it compares

Against the other 355 rated Udemy courses in Excel on CourseDuck:

  • Rating4.2 out of 5higher than 8% of them
  • Reviews1,615#133 of 356 by number of reviews
  • Length16.8 hourslonger than 86% of them
  • Last updatedNovember 2025more recently than 69% of them

icon
Course Description

Introduction to Excel VBA Programming

Excel VBA programming can seem baffling, especially when you don't fully understand the code you are asked to write. Learn to write Excel VBA macros, from scratch, to automate Microsoft Excel tasks and operations.

This course is aimed particularly at Excel users without much programming experience, who struggle to remember the syntax and structure of the VBA (Visual Basic for Applications) programming language.

During the introductory section, you will be introduced to a style of programming which emphasizes the significance of each line of code that you write. This means that when you revisit the code, the meaning of each line is apparent from the syntax, rather than becoming more and more unfamiliar. This introduction also demonstrates how to get the maximum benefit from IntelliSense, Microsoft's code completion feature.

Advanced Topics

Once we've covered the basics of Excel VBA programming, we'll move onto advanced topics.

You’ll learn how to create a workbook which can only be opened by a list of authorized users.   

How to create a chart event drill-down solution.   

You will learn how to create an accessible workbook which provides dynamic audio feedback to its users.   

You will create a solution which allows users to apply a filter to all tables within a workbook.   

You will build a sophisticated activity logging solution, which records every user action in a hidden worksheet.   

You will build an application which forces users to enter data via a user form while the underlying worksheet remains hidden.   

And you’ll learn how to add an alternative right-click menu and how to make it a permanent feature of Excel.   

Whether you are looking to enhance your career prospects by adding Excel VBA to your C.V., save your company money or increase your productivity, this series of Excel VBA courses will help you to broaden your Office programming skill set.

You can download all of the materials used in the lectures, so that you can follow along. (Please, remember to unZIP the downloaded files.)

icon
Udemy Discount

The discount is applied through our link. Open the course from here and Udemy's current promotional price is applied at checkout on most courses, no code to type.

Some courses are excluded from Udemy's promotions. If the price does not drop, clear your browser cookies and use the button again.

icon
Instructor Details

Grant Gamble

  Grant Gamble is an experienced IT trainer, developer, consultant and author able to deliver a wide range of training courses. He has a vast experience of delivering public and on-site IT training content at different skill levels, to groups of varying sizes. 

  His UK company G Com Solutions Limited provide IT training courses and consultancy to a wide range of UK and international clients. His speciality is running week-long, intensive training workshops on topics like Microsoft Power BI, VBA, web development and Adobe Creative Suite automation.

icon
More courses by Grant Gamble

$10.99

$11.99

$11.99

$14.99

$44.99

icon
More Excel courses

$39.99

Free

$99.99

Free

$15.99

$119.99

icon
Reviews

4.2

1,615 ratings on Udemy

Select a bar to show only those reviews.Select the bar again to show every rating.

By Michelle on 3/21/2022

I love the information. The example workbooks were awesome. However, the instructor hasn't answered questions in years. The audio quality on a couple videos, and the lack of transcripts, made the presentation useless. I would still recommend the course based on the information. After looking at other courses, this one is definitely at the top in terms of content, explaining the nitty gritty, and developing good coding habits.

By Wolfgang Ehrlich on 1/29/2021

I started the course "Hyper-disambiguated Excel VBA Programming" with part 2. But I soon realized that I had some gaps in my knowledge. That's why I booked part 1 also. That course teaches structured macro programming. It is explained in some videos based on overview pictures, what the programming is based on, e.g., on the VBA object model or the Excel object model. Mr. Gamble explains each step comprehensibly and understandable. The given programming examples are applicable in the real world. Great! From my point of view, both courses can be highly recommended.

By Jacqueline Sarvay on 11/30/2020

This course started off just as I expected. I could not stop doing the first few lessons! It was so rewarding to finally understand VBA in such a functional manner. I enjoyed the pace at which the first few lessons were delivered. However, I found that the last module of lessons so far were too rushed and I honestly did not appreciate codes appearing at warp speed, forcing me to rush and stop the video in a semi-panic every few minutes. Taking time presenting the codes make way more sense than rushing! I am hoping there is a change of pace in the remaining lessons. Everything else about this course has exceeded expectations. I am learning way more than I ever did in VBA. This course is thorough, exciting and rewarding at the same time.

By Erturul Ylmaz on 9/27/2020

seilen konular ve anlatlan eyler iyi ama anlatm ok robotik ve ses kalitesi gzel deil.
topics has been chosed are good but narration sounds robotic and hard to follow. Sound quality is bad.

By Caelum Doherty on 9/24/2020

Good useful content, some audio issues

By Matthew Owens on 9/16/2020

Still kind of hard to follow for me, really need to learn the vocabulary and terms more thoroughly.

By Rahul Kataria on 7/27/2020

It was what I was looking for to get a good understanding of VBA.

By Mluleki Ngwenya on 6/27/2020

Well presented even for novices

By Sateesh Ghattamaneni on 6/22/2020

Very much useful

By Juan Soler on 6/12/2020

While the content was useful, the pace was slower that I would like and there were annoying noises and low frequency humm throughout the videos.The Mic was very "boomy" as well.

By Radosaw Lament on 5/17/2020

very accurate comments, not omitting a single thing that can be subject to a question

By Vinaybhat on 4/24/2020

It is absolutely helpful for learning and to become a master in the VBA

Showing 12 of 186 reviews

icon
Quality Score

No CourseDuck member has rated this course yet. Taken it? Give each part a thumbs up or down.

Content Quality
/
Video Quality
/
Qualified Instructor
/
Course Pace
/
Course Depth & Coverage
/

Overall Score : 84 / 100