This is an introductory course on how to program Excel using VBA macros. You will learn to automate and extend the Excel environment to supercharge your Excel models, automate routine tasks, customize your user interface, and manage large quantities of data. This course is based on the instructor's semester-long college courses which have produced thousands of graduates in the fields of business, finance, health care and public policy. Designed for busy professionals who need to take their Excel abilities to the next level, you will not waste time on topics which you are unlikely to use, and you will receive extra attention to the often confusing or overlooked details that will make the most difference to your ultimate understanding. Over 8 hours of instruction!
This quiz covers the topics presented in Section 2.
Controlling program flow through repetition using variations of the For...Next loop.
Controlling program flow through repetition using variations of the For...Each loop.
Understanding variable scope: local, module and global, and when each should be used. How to declare variables of different scope.
Trapping runtime errors in your code, and providing simple error handlers to report the error and gracefully exit.
This short project combines and reinforces some of the skills and techniques introduced so far in the course: looping, simple and object type variables, defining and passing parameters, and using important Range properties such as CurrentRegion and Resize.
This quiz covers the topics presented in Section 3.
A look at additional techniques you can use to launch macros, by attaching them to objects on the worksheet or modifying the Quick Access Toolbar.
Modifying the Ribbon by adding tabs and groups; attaching macros to the Ribbon.
Hooking into Workbook and Worksheet events to run code automatically in response to user actions.
Hooking into Application events to run code automatically in response to keyboard actions and system time.
Exploring additional features of MsgBox, including modifying visual characteristics such as title bar, icon and buttons. How to test for user choices, OK/Cancel, Yes/No, etc...
Enhancing the Excel user interface by adding ActiveX controls to the worksheet, without using any code.
Presenting and gathering information through custom user forms: initializing controls, displaying and disposing of the form.
This quiz covers the topics presented in section 5.
A simple example of cross-application programming: reaching into Word from Excel to insert a chart and create a series of documents.
Mark Talbert has been using Excel aggressively since version 1.0, and writing Excel macros both before and after the introduction of the VBA language. He has introduced several college-level courses over 15+ years on Excel modeling and VBA programming, which have together produced thousands of graduates who now work across a wide range of industries. His most frequent email subject line from former students is "Thank God I took your course!" followed closely by "I really wish I would have taken your course!"