Create Excel apps with MySQL & Virtual Forms & Excel VBA
4.4 (73 ratings)
Course Ratings are calculated from individual students’ ratings and a variety of other signals, like age of rating and reliability, to ensure that they reflect course quality fairly and accurately.
5,137 students enrolled

Create Excel apps with MySQL & Virtual Forms & Excel VBA

Step-by-step Masterclass: Create quickly Excel VBA desktop apps using MySQL & Virtual Forms & VBA Excel 2010, 2013, 2016
4.4 (73 ratings)
Course Ratings are calculated from individual students’ ratings and a variety of other signals, like age of rating and reliability, to ensure that they reflect course quality fairly and accurately.
5,137 students enrolled
Created by Davor Geci
Last updated 1/2019
English
English [Auto-generated]
Current price: $49.99 Original price: $194.99 Discount: 74% off
30-Day Money-Back Guarantee
This course includes
  • 7.5 hours on-demand video
  • 2 articles
  • 42 downloadable resources
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
Training 5 or more people?

Get your team access to Udemy's top 3,000+ courses anytime, anywhere.

Try Udemy for Business
What you'll learn
  • You will be able to create with confidence fully-functional Excel VBA Database applications for CRUD (Create, Read, Update, Delete) that connects to MySQL database, with almost no coding.
  • You will easily create MySQL databases with Drag&Drop using MySQL Workbench in minutes, that we will use from Excel VBA, cutting out the useless fluff and filler.

  • Step by step walkthrough on how to make passive income with your Microsoft Excel & Virtual Forms applications leveraging a 3rd Party Affiliate web hosting.

  • Learn How to reuse projects from Excel VBA (created with Virtual Forms Framework) in Visual Studio 2017 VB NET or C#
  • Master Excel & VBA & MySQL & Virtual Forms (compatible with Excel 2007, Excel 2010, Excel 2013 or Excel 2016)
  • Make your work-life easier with Excel VBA advanced techniques, learn tips and tricks to improve your productivity, learn how to collect data for later data analysis​ and data visualization
Course content
Expand all 72 lectures 07:21:19
+ Introduction
1 lecture 05:49

This is the welcome Lecture for this Course:

"Create Excel VBA apps using MySQL database & Virtual Forms"

 Here you can see, in a few minutes, about what is this course all about.
Why we are using MySQL database as the data source for this course.
How to quickly create a MySQL database using MySQL Workbench.
How to use Virtual Forms Framework from within Microsoft Excel & VBA (Visual Basic for Applications).
How to convert our Excel VBA apps to Visual Studio 2017 C# or VB.NET with almost no changes to VBA code.
Also in this course, we will go through how to make some additional income with Affiliate programs if we want to create our applications for selling or giving them for free by leveraging 3rd party Web Hosting company where we will store our MySQL database.
And how to find a perfect and reliable hosting where we can maximize the commision rate and how some of the hosting providers have a sub referral commision and what is this second tier commision.

Preview 05:49
+ Setup your database
7 lectures 37:57

For our applications, we need to have a database where we will store our data.

We have decided to go with MySQL database because this is the most popular database technology out there. 
According to Stack Overflow yearly survey for 2018. Based on 63.000 developers that did answer this question, 58.6% of them say that they use MySQL in their development. On the second place is SQL Server with 41.6%

Preview 01:16

In this Lecture, we will learn how to install MySQL server & MySQL Workbench on your local machine.
What components to include that are mandatory for the projects that we build in this course and that will help us to connect from MySQL to Microsoft Excel & VBA (Visual Basic for Applications).
The MySQL Workbench is a FREE tool that enables us to quickly manage and create our MySQL databases, tables, views, relationships, triggers and other MySQL objects.

It can manage our MySQL databases no matter where they are, on your local machine, in your local network or on the web. 

MySQL server & MySQL Workbench installation
07:15

Here we will create our first MySQL database and create tables that we will later use in Microsoft Excel & VBA & Virtual Forms.
We will use the tool MySQL Workbench to visually create our MySQL database.

Creating a MySQL database and first tables using a model
10:36

What are the main conclusions of this section?

Quiz: Setup your database
3 questions
Creating first relationships or foreign keys
05:02
Create MySQL Database from Model (Forward Engineer)
04:23
Create a Model from MySQL Database (Reverse Engineer)
02:57
Update (Synchronize) MySQL database schema & Model
06:28
+ Starting with Virtual Forms & Microsoft Excel VBA
3 lectures 11:17

In this Lecture, you will learn what is Virtual Forms Framework for Microsoft Excel VBA.
How we can use Microsoft Excel & VBA and interact with our data that is in our database like MySQL, Microsoft SQL Server (MSSQL) or Microsoft Access using a small tool called Virtual Forms.
How we can use our normal Virtual Forms and transform it into the Lookup Virtual Form with almost no changes to Excel VBA code.

And how we can transform our Microsoft Excel VBA apps created with help from Virtual Forms for Excel and transform them to VB.NET or C# in Visual Studio 2017.

And other new and exciting things that we can do with Virtual Forms & Microsoft Excel & VBA & database like MySQL. 

Preview 04:26

Attached to this Lecture is the complete folder with the installation of Virtual Forms Framework for Microsoft Excel & VBA that we will need for our course.

Also, I will explain how you can download the latest Virtual Forms Framework for Microsoft Excel & VBA from the download section on the Virtual Forms webpage.

Downloading & Installing Virtual Forms Framework for Excel VBA
02:39

In this Lecture, we will go through the process of getting started, ie how to prepare a folder and a Virtual Forms definitions file that we will later utilize in Microsoft Excel and in Visual Basic for Applications (VBA) or when we will work with VB.NET or C # in Visual Studio 2017.

Setup your Project Files & Folders
04:12

What are the main conclusions of this section?

Quiz: Starting with Virtual Forms & Microsoft Excel VBA
3 questions
+ Creating a menu Userform in Excel VBA
2 lectures 04:43

If you are new to Microsoft Excel and (or) VBA (Visual Basic for Applications), in this Lecture you will learn how to prepare the environment that we will later use to develop our Microsoft Excel & VBA applications using Virtual Forms.
The Developer tab is one of the main places that we will use throughout the entire course and here we will learn how to enable it if you don't already have it shown.

Excel Developer Tab
01:14
Creating a MainMenu Userform in Excel VBA
03:29

What are the main conclusions of this section?

Quiz: Creating a menu Userform in Excel VBA
1 question
+ Adding first few lines of Excel VBA code
5 lectures 32:10
Adding a reference to the Virtual Form control in Excel VBA
02:00
Creating a public instance of the Virtual Form control object in Excel VBA
04:46
Writing Initialization and termination code in Excel VBA
21:40
Troubleshooting connecting to MySQL in VBA
00:23

If you get this error message "Class does not support Automation or does not support expected interface" in Excel VBA, after updating to a newer version, please try with this solution.

Tip: Error "Class does not support Automation or does not support expected inter
03:21
+ Creating our first Virtual Forms with Virtual Forms Designer for Excel VBA
6 lectures 51:08
Excel VBA code for opening the Virtual Form Designer
07:58
Tip: Why use Primary Key with Auto Increment
06:04
Creating more Virtual Forms and opening them from Excel VBA
06:36
Tip: "I call the ShowVirtualForm function and nothing happens"
06:34
+ Customizing Virtual Forms with Virtual Forms Designer for Excel
3 lectures 15:21
Change the Virtual Form caption and label captions
05:55
Change the decimal places
04:25
Maximum Length & Width of the Edit & Grid Field
05:01
+ Search for MySQL Database hosting
3 lectures 08:00
Section Introduction
00:36
What do we need for our database
02:55
Choosing the right hosting provider
04:29
Requirements
  • A computer with Windows & Excel (2007, 2010, 2013 or 2016) to install all the free and trial software and tools needed (I provide specific videos on installations for each tool)
  • Fundamentals or basic knowing of Excel & VBA are preferred (Visual Basic for Applications)
Description

Microsoft Excel & Microsoft Power BI are the most popular and used tools for analyzing and visualizing data.

BUT, Microsoft Excel is not created for gathering data, especially in gathering relational data like master-detail structures.

One basic, simple Excel example. You want to gather (or track) Orders in Excel and then for this Orders you want to track Order Details and, for example, Order Payments and all that using Excel.

Not to mention, to do this in a multi-user environment also in Excel

Boy,….., You will have a tough time to do this with Excel, because Excel is simply not created for challenges like this, to gather master-detail data and also in a multi-user environment within the normal Excel environment.

But in this course “Create Excel VBA apps using MySQL database & Virtual Forms“, You will learn how you can do this by using Excel VBA as a front end and MySQL database as a backend, whether the MySQL database is on your local machine, your local network, or on the web server. We will do this with help of a small tool called Virtual Forms.

Hello,

I’m Davor Geci the CEO and the Lead Developer of WinPIS, the company that’s behind a popular tool that brings to Excel what Access developers are having for decades.

It is the ability to create CRUD Forms in Excel, forms to createreadupdate and delete records that are stored in databases like MySQLMSSQLAccess (On-premise or on the web) and use the data within Excel VBA and all that in minutes.

It is similar to what Access can do, but you could also port this Virtual forms from Excel VBA to Visual Studio 2017 (C# or VB.NET), Python,....

You can not do this with Access VBA or natively with Excel VBA !

So, you just need to create a database and tell the Designer which fields you want on your form that is opened from Excel VBA code.

Once created Virtual Forms can be also used as LookUp forms in Excel VBA with no extra work, just as you would do VLOOKUP an HLOOKUP in Excel functions & formulas.

All the controls that are generated on this Virtual forms can be accessed with Excel VBA (or if you use Visual Studio 2017 with  C# or VB.NET).

Virtual form control also fires events, so it allows us to interact with it, in a similar way normal UserForms in Excel VBA do. But in a more data-centric way.

Before you dive in, it’s probably a good idea to just check out the structure of the course “Create Excel VBA apps using MySQL database & Virtual Forms”.

In this course, You will learn how to quickly create database applications using Microsoft Excel VBA and a MySQL database that is hosted somewhere on the internet or in your building (so-called on-premise) and all that with help of the Excel VBA & a small tool called Virtual Forms.

In the first part of this course, You will learn how to create your first database app that will use Excel VBA as a front end, and a MySQL database as the back end. You will also learn how to install a MySQL server on your machine or anywhere in your network and use it as a data source. Also, in the first part of the course, you will learn how to install and use MySQL Workbench that help us to create and maintain MySQL databases.

Don’t worry, I will go slow!

Not only you will learn how to create your Excel Virtual Forms and write a few lines of Excel VBA code to master them,

you will also learn how you can make money with your Excel apps by leveraging an affiliate program from a 3rd party web hosting company where you will host MySQL database.

And then, you will also learn how to transform your Excel VBA database applications with MySQL database as the datasource to C# or VB.NET with almost no change to the Excel VBA code.

We will also create Excel apps with other datasources, like Microsoft Access database and Microsoft Excel Workbook.

If you ever get stuck with something in the course, (like Excel VBA code or MySQL databases) just post a message in the Q&A of this course and I will respond as soon as I can to help you out. I do everything I can to make this a 5-star course and I hope you like it too and leave a review.

Feel free to take a look at preview lectures and the course description before making a decision to buy.

And yes, this course is covered with Udemy 30-day money back guarantee.

You don’t have anything to lose.

So, enroll now, try it out, learn new things in Excel VBA and MySQL, have fun with me and create your Microsoft Excel VBA apps in minutes. 

Join me inside NOW!

Davor

Who this course is for:
  • This may not be a course for a Excel Complete Beginner, but certainly for Excel Intermediate and Excel Expert level users who want's to learn advanced Excel VBA and raise theirs​ Office Productivity
  • Want to Master Excel & Quickly learn to build stunning Desktop Database Applications in Excel VBA & MySQL database in minutes.
  • Business Professionals & data analyst who'd like to learn to simplify & automate workflow using Excel & VBA
  • You currently use Excel and want to learn how to improve your skills from Beginner to Advanced in Excel VBA programming
  • Want to learn Excel VBA advanced techniques - How to Master Microsoft Excel from Beginner to Advanced and collect data for later data analysis​ and data visualization
  • Want to become an Excel Expert on All Levels (from Excel Basic to Excel Intermediate and Excel Expert level)
  • This has not been tested on Mac Excel