Excel VBA Macros: Hyper-disambiguated Excel VBA Programming

About Excel VBA Macros: Hyper-disambiguated Excel VBA Programming

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.)