VBA: Building User Interfaces with Forms in VBA & Excel

About this course

One of the many capabilities of Excel's VBA is building complex user interfaces within Excel. Part of this is the creation of complex forms for gathering input data. In this course, you'll learn how to create user forms using VBA in Excel and, in doing so, achieve user interfaces with complex controls like combo boxes and spinners. You'll also learn how to send emails from VBA while being mindful of security risks and the configuration required if the email provider is Gmail. You'll learn how to validate form input data, insert it into an Excel spreadsheet, and illustrate how such user input can be accepted using complex controls, such as radio buttons and checkboxes, and buttons that, when clicked, trigger the invocation of VBA subroutines.

Learning objectives

• Discover the key concepts covered in this course
• Introduce user forms as a way to add complex uis to an excel workbook and use the vba forms control toolbox to add elements, such as buttons, to a user form
• Wire up a button to vba code so that whenever that button is clicked a message is displayed, design a fully-fledged user form to accept complex user input using input boxes, and configure buttons to submit or reset that user input