Validating Controls 
Validating Controls
by WiseOwl
Video Lecture 4 of 20
Not yet rated
Views: 184
Date Added: May 16, 2017

Lecture Description

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.

Course Index

Course Description

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.

Comments

There are no comments. Be the first to post one.
  Post comment as a guest user.
Click to login or register:
Your name:
Your email:
(will not appear)
Your comment:
(max. 1000 characters)
Are you human? (Sorry)