If you would like to support Wise Owl in their quest to turn tea and biscuits into high quality training videos, you can click this link https://www.wiseowl.co.uk/donate?t=1 to make a donation. Thanks for watching!

You can buy our book “Introduction to Excel VBA” here: https://www.lulu.com/shop/andrew-gould/introduction-to-excel-vba/paperback/product-23301058.html

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

https://www.wiseowl.co.uk – Validation is about making sure a user has entered sensible values into a control. This video shows you how to use the 'Before' and 'Afterupdate' events of a text box to prevent a user from continuing if they have entered invalid data. You'll learn how to check if a value is a number or a date, and how to change the properties of controls at runtime to indicate that there is a problem.

Visit www.wiseowl.co.uk for more online training resources on Microsoft Excel, SQL Server, Reporting Services, Analysis Services, Integration Services, ASP.NET, C#, Visual Basic, Microsoft Access, Microsoft PowerPoint, Microsoft Word, Microsoft Project, Microsoft Publisher, Microsoft Visio and more.

Please take the opportunity to connect with your friends and family and share this video with them if you find it useful.