Excel VBA Macros: Hyper-disambiguated Excel VBA Programming
- 11.5 hours on-demand video
- 1 downloadable resource
- Full lifetime access
- Access on mobile and TV
- Certificate of Completion
Get your team access to 4,000+ top Udemy courses anytime, anywhere.Try Udemy for Business
- 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.
- Experienced Excel users who are new to Excel VBA programming.
This is a Udemy best-selleing course. Here is some of the feedback from other students:
"Best intro I've seen for a non programmer. Explains key concepts well." Ron Willett
"Wonderful way of teaching. Shows the full hierarchy of both Excel and VBA objects. Now know the differences." Bill Malemba
"Concise, thorough, yet repetitive enough to allow the concepts to stick. Love the real-world examples and the emphasis on concepts over code parroting. Best VBA tutorial I've found, hands down, bar none - covers top to bottom application/VBA structure which is immensely helpful. Well-organized, all code can be re-visited with provided worksheets..." Dy622
"this is my favourite excel vba course. Lot of exercises, lot of different area is covered, and really explains everything from step 1, not just the how, but the why as well. thanks to the course I understand vba and macros better than ever before."
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 course, we will use 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. The course also demonstrates how to get the maximum benefit from IntelliSense, Microsoft's code completion feature.
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 course will provide your with all the knowledge you need to get started.
You can download all of the materials used in the lectures, so that you can follow along. (Please, remember to unZIP the downloaded files.)
- Anyone wishing to learn professional Excel VBA programming techniques.
This video provides an overview of Excel VBA and what you will need to learn in order to start writing your own macro.
The Developer Tab is not visible on the Excel Ribbon by default. This video shows you how to make the Developer Tab visible in Excel.
For your protection, Excel displays a warning message each time you open a workbook containing macro code. This tutorial shows you how to prevent these messages being displayed when working with your own macros.
In this video, we begin our look at the Visual Basic Editor, the environment in which VBA code is edited, by examining the role of the Project Explorer window.
In this lesson, we continue our look at the Visual Basic Editor by discussing the function of the Excel Objects folder found in the Project Explorer.
In this lesson, we examine the Excel object model; the programmatic representation of the elements within the Excel user interface.
This lesson demonstrates the use of If statements, the key conditional structure in VBA programming.
This video shows you how to modularize your code by splitting it into separate sub-procedures and how to define module-level variables whose contents can be accessed from any sub-procedure.
If your macros need to change a user's Excel settings, it is good etiquette to restore them to their original values. This tutorial gives an example of this best practice technique.
In this chapter, we practice our code recognition skills, categorizing each line of code according to the function it performs within the macro.