Excel VBA Advanced Filter Database Form
In this tutorial, I'll show you how to create a database application using only Excel VBA without any actual databases, such as Microsoft Access.
This tutorial gives a quick overview of some database concepts like how vlookup is similar to a database match and demonstrates how VBA can be combined with the Advanced Filter in Excel and VBA forms to create a database like application in Excel without using a database.
The way this is designed means it can be migrated to a proper database in the future if the need arises.
✅ Excel VBA Programming for Dummies (affiliate) with reviews https://amzn.to/3lhnWOy
✅ O'Reilly writing Excel Macros With VBA https://amzn.to/3tmPm8M
✅ This video use techniques found in the video link below ...
"How To Make An Excel VBA Listbox Behave Like A Grid" • How To Make An Excel VBA Listbox Beha...
This playlist covers all my advanced filter videos in this series.
✅ Excel VBA Advanced Filter Playlist • Excel Advanced Filter
☕
If you found this tutorial helpful consider supporting this channel with a steaming hot cup of coffee... https://buymeacoffee.com/seanjohnson
☕
Video Production
===============
Sony Camera: https://amzn.to/3mqyqfu
Elgato HDMI Stream Capture: https://amzn.to/2Yfyrum
Microphones
-----------
Screen Casting: https://amzn.to/3a2TnHN
Microphone and Arm : https://amzn.to/3iwvL2S
Talking To Camera: https://amzn.to/3FqXI6b
Video Kit
-------------
Lights
Elgato video Lights: https://amzn.to/3sSK3xg
Background Light: https://amzn.to/3uTXyPh
Note Taking
-----------
Rocketbook reusable notebook https://amzn.to/3sSK3xg
#ExcelVBA #AdvancedFilter #Excel #VBA #msExcel
DISCLAIMER: This video and description contain affiliate links, this means if you click on one of the product links, I’ll receive a small commission.
If you do use one of the links, thanks I appreciate it.
