Channel: TeachExcel

Category: Education

Tags: checkbox excelinput validation userformcombobox exceluserform controls exceloptionbutton excellistbox excel

Description: Full Course: teachexcel.com/vba-course-update.php (Downloadable files are in the full course.) Free Couse Playlist: youtube.com/watch?v=QQNQObpAjL8&list=PLxhsXZXQXrUCKGlVG8xanGfvSX6h50a5Q Part 2 of the UserForm Course - this tutorial covers many popular userform controls and shows you how to create them, put values into them, and store their values and selections in the worksheet. UserForm Controls & Topics Covered Here: - ComboBox in UserForms in Excel. - ListBox in UserForms in Excel. - OptionButton in UserForms in Excel. - CheckBox in UserForms in Excel. - CommandButton in UserForms in Excel. Full Version Includes: - Input validation. - ComboBox validation. - Input error message output. - Robust coding practices that are easier to manage and control. - Easy looping through OptionButton controls to figure out which option was selected and store its value in Excel. - Looping through specific groups of option buttons to get their selection values. Many more features, and topics are also included in the full course - this tutorial is just a sample! Excel Courses: - VBA/Macro Course: teachexcel.com/vba-course-update.php - Building Professional Forms: teachexcel.com/premium-courses/68/idiot-proof-forms-in-excel?src=youtube_v_jjGIwoToOC4 - Email Course: teachexcel.com/premium-courses/96/send-emails-from-excel-course?src=youtube_v_jjGIwoToOC4 TeachExcel.com #msexcel #howto #tutorial