1. Home
  2. Docs
  3. What is Virtual Forms Framework
  4. What is Virtual Forms Framework?

What is Virtual Forms Framework?

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,…)

 

 

 

Example:

 

 

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).

 

Ways to create data entry forms in Excel (Userforms)

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.

 

New data entry forms (Userforms) in Excel with Virtual Forms Framework

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 more “professional” or “robust” database (relational database), as for example:

  • Microsoft Access database
  • MySQL server
  • Microsoft SQL server, or other…

Data in relational database but Forms and programming in Excel and VBA

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 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 do in Excel.

 

Standalone exe applications

Yes, this can also be done with Virtual Forms Framework and, for example, Microsoft Visual Studio 2017 community edition (it’s free).
There would be a few lines of code needed to make it work, but it is doable. And all work done in Virtual Forms Designer would work without changing, only the code that we would write in VBA would need some little change, but not a lot, because Microsoft Visual Studio 2017 is having Visual Basic.NET that is 90% the same as the VBA.
Was this article helpful to you? Yes No

How can we help?