Excel Step-by-step Masterclass: Create Excel VBA apps with MySQL & Virtual Forms & Excel VBA | Davor Geci | Skillshare

Excel Step-by-step Masterclass: Create Excel VBA apps with MySQL & Virtual Forms & Excel VBA

Davor Geci, [email protected], Programmer | Excel VBA

Play Speed
  • 0.5x
  • 1x (Normal)
  • 1.25x
  • 1.5x
  • 2x
55 Videos (5h 16m)
    • Course Introduction

      5:11
    • Why MySQL as a database

      1:16
    • MySQL server & MySQL Workbench installation

      7:15
    • Creating a MySQL database and first tables using a model

      10:36
    • Creating first relationships or foreign keys

      5:02
    • Create MySQL Database from Model (Forward Engineer)

      4:23
    • Create a Model from MySQL Database (Reverse Engineer)

      2:57
    • Update (Synchronize) MySQL database schema & Model

      6:28
    • About Virtual Forms for Excel VBA

      4:26
    • Downloading & Installing Virtual Forms Framework for Excel VBA

      2:39
    • Setup your Project Files & Folders

      4:12
    • Excel Developer Tab

      1:14
    • Creating a MainMenu Userform in Excel VBA

      3:29
    • Adding a reference to the Virtual Form control in Excel VBA

      2:00
    • Creating a public instance of the Virtual Form control object in Excel VBA

      4:46
    • Writing Initialization and termination code in Excel VBA

      21:40
    • A quick answer to our connection string challenge

      1:48
    • Troubleshooting connecting to MySQL in VBA explained in detail

      28:11
    • Tip: Error "Class does not support Automation or does not support expected interface

      3:21
    • Excel VBA code for opening the Virtual Form Designer

      7:58
    • Explaining the Virtual Form parts (structure)

      5:57
    • Create your first Virtual Form with VF Designer for Excel

      17:59
    • Tip: Why use Primary Key with Auto Increment

      6:04
    • Creating more Virtual Forms and opening them from Excel VBA

      6:36
    • Tip: "I call the ShowVirtualForm function and nothing happens"

      6:34
    • Change the Virtual Form caption and label captions

      5:55
    • Change the decimal places

      4:25
    • Maximum Length & Width of the Edit & Grid Field

      5:01
    • Create a simple Lookup Virtual Form

      5:20
    • Search for MySQL Database hosting - Intro

      0:36
    • What do we need for our database

      2:55
    • Choosing the right hosting provider

      4:29
    • Passive income through a web hosting affiliate program - Intro

      1:26
    • What is affiliate marketing in few simple words

      7:23
    • Setting up MySQL server and database on a shared hosting - Intro

      0:43
    • Creating an account with your web hosting provider

      4:30
    • Creating a MySQL database on a shared hosting server

      4:18
    • Export your database to MySQL server on Shared Hosting using Forward Engineering

      9:13
    • Differences between Windows & Linux related to the MySQL server

      17:56
    • Changing connection string from local to hosted MySQL database in Excel VBA

      10:41
    • From Excel VBA to VB.NET

      17:12
    • Creating a Customers table using a SQL script

      7:56
    • Add Customers Virtual Form to Main Menu Userform in Excel VBA

      7:29
    • Grid control change the order of columns

      2:32
    • Grid control change the width of columns

      1:30
    • Grid control initial sort field

      1:46
    • Grid control hide column

      1:23
    • Grid control change the Alignment of the grid column

      1:41
    • Virtual Forms partially responsive design

      2:16
    • Edit control change the Tab order of Textboxes

      3:06
    • Edit control change position of Textboxes

      7:20
    • Edit control change the Tab order of Textboxes 1

      1:30
    • Edit control responsive design after repositioning of Textboxes

      1:05
    • Edit control reset the positions of Textboxes

      1:43
    • See us in the next lesson - This is not the END

      1:01

About This Class

Excel Step-by-step Masterclass-Create Excel VBA desktop apps using MySQL database quickly with Virtual Forms & Excel VBA

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.

And then you can connect to this data from Excel and use it whether we want to: 

  • create dynamic reports with Excel Pivot Tables & Pivot Charts & Graphs 
  • data analysis 
  • financial modeling 
  • help identify trends & forecasting
  • create Excel Dashboard
  • use Excel formulas & functions
  • analyze Statistics using Excel or Power BI on that collected data
  • and many other interesting and useful things

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 create, read, update and delete records that are stored in databases like MySQL, MSSQL, Access (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)

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.

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. 

--------------------------------------------------

What will you achieve or be able to do after taking this course?

  • How 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
  • How to easily create MySQL databases with Drag&Drop using MySQL Workbench in minutes, 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
  • 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
  • Make your work-life easier with Excel

What knowledge & tools are required?

  • You need to have Windows version of Microsoft Excel
  • Fundamentals of Excel & VBA are preferred
  • A computer with Windows & Excel to install all the free and trial software and tools needed to build your new Excel VBA apps that connect to MySQL database (I provide specific videos on installations for each tool)

Who should take this course?

  • Want to Quickly build stunning Desktop Database Applications in Excel VBA & MySQL database in minutes
  • Business Professionals who'd like to simplify & automate workflow using Excel & VBA
  • You currently use Excel and like to improve your skills

So, Join me inside NOW!

Cheers, Davor

18

Students

--

Projects

  • --
  • Beginner
  • Intermediate
  • Advanced
  • All Levels
  • Beg/Int
  • Int/Adv

Level

Community Generated

The level is determined by a majority opinion of students who have reviewed this class. The teacher's recommendation is shown until at least 5 student responses are collected.

Davor Geci

[email protected], Programmer | Excel VBA

Davor is a veteran programmer with 20 years of being a professional programmer and 15 years of building companies as CEO or helping others as an HR consultant in employee recruitment.

Specialties: VB, VBA, Error Handling, Azure Application Insights, SQL, Databases, Excel, Access, MySQL, MSSQL.

Currently: CEO & Founder at WinPIS

Recent projects:

Virtual Forms for Microsoft Excel VBA (NEW UserForms for Excel VBA)

VBA Telemetr...

See full profile

Report class