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-forms.htm

www.wiseowl.co.uk - Another aspect of validation is checking that every control on a form has been filled in. This video explains how to loop over the controls collection to check if every textbox has been completed.

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.