We all love Microsoft Excel, but sometimes it can be a real pain in the ass when we are trying to use it as a database or table for our data.
Not to mention when trying to visually display and be able to update the data that we have in a relational structure. Eg. Orders > Order Details & Order Payments
So, the Virtual Forms Framework enables you to Create and Use Simple and Advanced forms directly from Microsoft Excel and VBA. Like:
- Forms for CRUD (create, read, update, delete records)
- LookUp forms, for example:
- Master-Detail forms, for example:
Let’s say that you need a simple Order management system for your Computer store.
So, you will have Orders, Order Payments, Orders Details (Products) and some of this products can be made from Components.
(You can sell Computers made from Components (Graphics cards, Motherboards, Monitors,…), but you can also sell individually these Components as Products (Monitors, Graphics cards, Motherboards,…)
If you are an advanced user of Microsoft Excel or a beginner, or just want to create a simple database with Excel, you will, sooner or later, get to that point when you want to make a simple or complex entry form for entering the data in your database (whether it is a Microsoft Excel Workbook, Microsoft Access database, MySQL database or MS SQL database).
Whether you want to use Excel Workbook as the database or any of the relational database, if you try to create this entry form in Microsoft Excel you can do this in two ways:
1. Using the built-in Excel data form, or
2 Create a custom UserForm in VBA
But now there is also a 3. way:
3. Create Virtual forms
The 1. way lets you quickly create a simple data entry form and there is no way to customize it (“what you see is what you get”).
With the 2. way you can create a custom data entry form (UserForm) but it will take you a lot of time and you must be an advanced programmer to create anything usable.
And when the number of forms increases, maintaining them becomes a nightmare.
The 3. way is the Virtual Forms way.
The Virtual Forms Framework enables you to quickly create stunning data entry forms (Userforms) in Excel, in most cases without the need to write a single line of code, in minutes.
And you are not limited to only use the Excel Workbook as the datasource for your data.
With time, as your application grows, you will want to move your data to a more “professional” or “robust” database (relational database), as for example:
- Microsoft Access database
- MySQL server
- Microsoft SQL server, or other…
When that time comes, or maybe you want to reconsider right from the start to go with a “professional” database as a home for your data. You don’t need to learn a new programming language, you can do that all with Virtual Forms directly from Excel and VBA.
Virtual Forms will let you choose what datasource you want to use for your data (Excel, Access, MySQL, MSSQL) and create the data entry forms (Virtual Forms) directly within Excel and VBA.
For example, you can store the data in MySQL database, manipulate (CREATE, READ, UPDATE and DELETE (CRUD)) with help of Virtual Forms, and import the data you need to Excel to do all the magic that we are used to doing in Excel.