Introduction to Graphical User Interface (GUI) and Debugging in Excel VBA

Name: Introduction to Graphical User Interface (GUI) and Debugging in Excel VBA (English version)
SKU: 9B11E020

Mehmet A. Begen; Dennis Li

Product #:9B11E020

Supplier:Ivey

Discipline:Management Science

Setting:2011

Details:Note (PDF) • 16 pages • 2011-08-15

Subjects:

Analytics and data science Data science

Your Price:

$9.71

Purchase this material with a free Educator Account and enjoy more benefits:

Free Educator Copy
Free Teaching Notes
Build your coursepack
Discounted academic price

Microsoft Excel offers a suite of graphical user interface (GUI) tools that can be used with Microsoft’s Visual Basic for Applications (VBA) code. These tools enable the creation of programs with a customized appearance and function. Thus, highly complex models can be made simple to use.

This note, using explanations and examples with screenshots, is designed to give readers an overview of the available GUI and debugging tools within Excel VBA. It is intended for students who already have experience with basic VBA programming.

Learning Objectives

This note can be used as an introductory reading or as lecture notes in a course that teaches and/or requires Excel VBA and macros.