VBA: Building User Interfaces with Forms in VBA & Excel
One of the many capabilities of Excels VBA is building complex user interfaces within Excel. Part of this is the creation of complex forms for gathering input data. In this course youll 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. Youll also learn how to send emails from VBA while being mindful of security risks and the configuration required if the email provider is Gmail. Youll 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.