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 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
Wire up a complex user form to store data in an excel workbook
Add 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 provider
Develop a complex user form and add complex controls such as dropdown menus (known as combo boxes in vba), checkboxes, radio buttons, and spin buttons
Add 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 workbook
Wire 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 excel
Summarize the key concepts covered in this course
IN THIS COURSE
-
2m 8s
-
10m 28s
-
3. Connecting a User Form to an Excel Workbook with Buttons10m 27s
-
4. Storing Data from a User Form into an Excel Workbook9m 55s
-
5. Using a User Form to Insert rows into an Excel Spreadsheet7m 5s
-
6. Sending Mail from Excel with VBA10m 24s
-
7. Building Complex User Forms9m 32s
-
8. Opening, Closing, and Submitting User Forms9m 21s
-
9. Using a Form with Complex Controls10m 58s
-
10. Course Summary1m 58s
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.
