Amazing and Dynamic Risk Management System
Build risk management system in Excel VBA if you have NO or LIMITED VBA knowledge. If you want to quickly use Visual Basic for Applications (VBA) to build user forms in Excel, this tutorial is for you. You will be exposed to a set of procedures that you can use out of the box to develop Excel userform easily and quickly in a step-by-step guide. In this tutorial, you will know the processes and the VBA code involved in building risk management system application in Excel.
We will learn how to create a data entry form in Excel using controls like: List Box, Text Box, Combo Box, and Command Button. The userform will be designed with both accelerator keys and tab order. We will set up a worksheet as a database and briefly explain primary and foreign keys and relationship between tables. In this video, there is a reason for why using backend names for objects in VBA are preferable to frontend captions. We will know how to easily code a multi-dependent dropdown button. We will learn how to efficiently write form data to a worksheet.
Timestamps
00:00 Intro and Demo
01:02 Download Starter Workbook
01:42 Setup Worksheet as Database
07:51 Worksheet Backend/Code Names
09:44 Design Userform with Controls
13:15 Run Userform for the first time
13:57 Modular Procedures Technique
15:10 Initialized Userform
16:35 Make Date Pickers
20:09 Populate Combo-Box with Range Values
23:30 Multi-dependent Combo-Boxes/Dropdowns
27:45 Populate Textbox based on Combo-box
30:56 Write Userform Data to Worksheet
32:48 Conclusion
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/1gOWq...
Смотрите видео Amazing and Dynamic Risk Management System онлайн без регистрации, длительностью часов минут секунд в хорошем качестве. Это видео добавил пользователь fiiinspires 16 Май 2021, не забудьте поделиться им ссылкой с друзьями и знакомыми, на нашем сайте его посмотрели 3,194 раз и оно понравилось 73 людям.