Data Validation for Required Fields in Userform Applications
This tutorial is about using modular procedure to avoid excessive VBA code when building Excel userform applications. We look at a reusable VBA procedure for validating required fields in a userform. The focus is how to save time and use maintainable VBA code.
We look at two independent VBA functions. One checks if a field marked as required has a value and the other raises a message to indicate that a field should have a value.
Timestamp
00:00 Intro
00:48 Coding Required Fields Data Validation
01:48 Introduction to 1-Line Data Validation
03:22 Set Tag Property of a Control
04:27 Write the 1-Line Code
05:28 Test the Data Validations
06:09 Usefulness of the 1-Line Code
Keyboard Shortcuts
ALT + F11 to access the visual basic editor (VBE)
F5 to run a selected VBA code or userform
F7 to access the code view of a userform
F4 to show properties window in VBE
CTRL + R to access Project Explorer in VBE
Download
https://drive.google.com/file/d/1AjUe...
Смотрите видео Data Validation for Required Fields in Userform Applications онлайн без регистрации, длительностью часов минут секунд в хорошем качестве. Это видео добавил пользователь fiiinspires 24 Май 2021, не забудьте поделиться им ссылкой с друзьями и знакомыми, на нашем сайте его посмотрели 3,892 раз и оно понравилось 60 людям.