Excel VBA Forms Part 4 - Validating Controls
If you'd like to help fund Wise Owl's conversion of tea and biscuits into 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 Introduction to Excel VBA book here https://www.lulu.com/shop/andrew-gould/introduction-to-excel-vba/paperback/product-23301058.html
By Andrew Gould
Download files here https://www.wiseowl.co.uk/videos/excelvbauserforms/validating-controls.htm
https://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.
Visit www.wiseowl.co.uk for more online training resources in 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
Видео Excel VBA Forms Part 4 - Validating Controls канала WiseOwlTutorials
You can buy our Introduction to Excel VBA book here https://www.lulu.com/shop/andrew-gould/introduction-to-excel-vba/paperback/product-23301058.html
By Andrew Gould
Download files here https://www.wiseowl.co.uk/videos/excelvbauserforms/validating-controls.htm
https://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.
Visit www.wiseowl.co.uk for more online training resources in 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
Видео Excel VBA Forms Part 4 - Validating Controls канала WiseOwlTutorials
Показать
Комментарии отсутствуют
Информация о видео
Другие видео канала
Excel VBA Forms Part 5 - Validating FormsExcel VBA Forms Part 3 - Adding Code to a FormHow to allow only input of numerical values in userform text-box using Excel VBACreate Excel Pivot Table using VBA | Excel VBA AutomationDate Picker Control - Excel VBA Data Entry Userform (Part 4)Create An Excel Data Entry Form With UserForm - Add, Update, Delete and SaveMulti User Data Entry Form in Excel VBA (Part-1)Excel VBA Introduction Part 5 - Selecting Cells (Range, Cells, Activecell, End, Offset)Excel VBA Forms Part 6 - ComboBox ControlsIdiot-Proof Forms in Excel - Part 4 - Protect Your FormExcel VBA Forms Part 7 - ListBox ControlsHow To Validate Userform Inputs With Excel VBA (Excel Userforms For Intermediates 2)VBA: Multilevel dependent drop-down in User FormExcel VBA Forms Part 9 - Spin ButtonsExcel VBA Userform that Only Allows Numeric EntriesExcel VBA Tutorial 15 - UserForm with Textbox, Checkbox, ListBox, Option Button and Command ButtonDependent Combo Boxes with Advanced Filter - Excel VBAExcel VBA Forms Part 14 - Multi Page ControlsExcel VBA Forms Part 1 - Drawing Forms