If you'd like to help fund Wise Owl's conversion of tea and biscuits into quality training videos you can click this link www.wiseowl.co.uk/donate?t=1 to make a donation. Thanks for watching!

By Andrew Gould
Download files here www.wiseowl.co.uk/videos/excelvbauserforms/validating-controls.htm

www.wiseowl.co.uk - Validation is all about making sure a user has entered sensible values in a control. This video shows you how to use the before- and afterupdate events of a textbox to prevent a user continuing when they've entered invalid data. You'll learn how to check if a value is a number or a date and how to modify the properties of controls at runtime to indicate that there's a problem.

1. Drawing Forms
2. Running and Navigating Forms
3. Adding Code to a Form
4. Validating Controls
5. Validating Forms
6. ComboBox Controls
7. ListBox Controls
8. Option Buttons
9. Spin Buttons
10. Scroll Bar Controls
11. Check Boxes
12. Toggle Buttons
13. Image Controls
14. Multi Page Controls
15. Tab Strip Controls
16. Playing YouTube Videos
17. Editing Data
18. Installing the Date Time Picker and Month View Controls
19. Using the RefEdit Control
20. Progress Bars

This tutorial explains how to create user forms in Excel VBA taking you from the very basics of drawing and formatting forms, through discussions of the various controls that you can add, and on to even more advanced features.