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