Data Validation for Required Fields in Userform Applications
Автор: fiiinspires
Загружено: 2021-05-24
Просмотров: 4416
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...
Доступные форматы для скачивания:
Скачать видео mp4
-
Информация по загрузке:
