Amazing and Dynamic Risk Management System - Data Validations

Published: 25 May 2021
on channel: fiiinspires
975
27

In this tutorial, we will look at the data validations that our risk management system should have. We briefly discuss the usefulness of data validations and how to approach it. We look at mandatory fields and how to apply a common validation to all of them. We code the validations applicable to the dates in our risk management application. We explore date functions, when and when not to use them.

VBA Date Functions and Concepts
DateSerial
DateValue
IsDate

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/10TbJ...


Watch video Amazing and Dynamic Risk Management System - Data Validations online without registration, duration hours minute second in high quality. This video was added by user fiiinspires 25 May 2021, don't forget to share it with your friends and acquaintances, it has been viewed on our site 97 once and liked it 2 people.