Channel: TeachExcel

Category: Education

Tags: userform exceluserform usability excel

Description: Full Course: teachexcel.com/vba-course-update.php (Downloadable files are in the full course.) Playlist: youtube.com/playlist?list=PLxhsXZXQXrUCKGlVG8xanGfvSX6h50a5Q Part 5 of the UserForm Course. Make a form easier to use in Excel by allowing the user to close it using the Esc key on the keyboard and by dynamically locking/disabling/enabling controls in the form. You will learn how to choose when to enable a control based on other inputs into the UserForm, such as checking a checkbox, which is what I show you how to do here. UserForm Controls & Topics Covered Here: - Closing forms by hitting the Esc key. - Locking/unlocking controls, which allows their values to still be selected. - Disabling/enabling controls which completely greys-out a control and renders it useless. Full Version Includes: - Hiding/Showing controls and groups of controls. - Setting a specific command to run when you hit the Enter key. - Going to, and activating, specific controls, even if they are on a different page or tab. - Managing the order of tabing, across multiple pages and controls. - More precise control positioning when designing the form. 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_PtMSpXKcYxY - Email Course: teachexcel.com/premium-courses/96/send-emails-from-excel-course?src=youtube_v_PtMSpXKcYxY TeachExcel.com #msexcel #howto #tutorial