VBA: Building User Interfaces with Forms in VBA & Excel
VBA 7.1 (Office 2019) | Intermediate
- 10 videos | 1h 22m 16s
- Includes Assessment
- Earns a Badge
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.
WHAT YOU WILL LEARN
discover the key concepts covered in this courseintroduce 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 formwire 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 inputwire up a complex user form to store data in an Excel workbookadd a button to a workbook to display a complex user form and demonstrate the resulting fully-fledged user application from Excel
use VBA's support for sending emails from within macros, enable and use Microsoft CDO (Collaboration Data Objects), recognize security flaws for sending emails from VBA, and identify the setup required if Gmail is the mail providerdevelop a complex user form and add complex controls such as dropdown menus (known as combo boxes in VBA), checkboxes, radio buttons, and spin buttonsadd complex controls to an app, including spin buttons and checkboxes, create a close button to unload the form's memory and cease displaying it, and add a submit button to store user input in a workbookwire up the back-end code to process user inputs from the form, create a display button to show the form, and demonstrate the resulting fully-fledged user application from Excelsummarize the key concepts covered in this course
IN THIS COURSE
EARN A DIGITAL BADGE WHEN YOU COMPLETE THIS COURSE
Skillsoft is providing you the opportunity to earn a digital badge upon successful completion on some of our courses, which can be shared on any social network or business platform.Digital badges are yours to keep, forever.
YOU MIGHT ALSO LIKE
PEOPLE WHO VIEWED THIS ALSO VIEWED THESE
Course Managing macros in Excel 365