Home
Courses List
Pricing
My Account

Courses
Create Excel apps with MySQL & Virtual Forms & Excel VBA
Creating a menu Userform in Excel VBA
Excel Developer Tab

Excel

Video/Text

Excel Developer Tab

Lesson 12 Chapter 4

Previous Lesson
Next Lesson

Progress

Not started

Course Structure

Introduction

Course Introduction

Not Viewed

Setup your database

Why MySQL as a database

Not Viewed

MySQL server & MySQL Workbench installation

Not Viewed

Creating a MySQL database and first tables using a model

Not Viewed

Creating first relationships or foreign keys

Not Viewed

Create MySQL Database from Model (Forward Engineer)

Not Viewed

Create a Model from MySQL Database (Reverse Engineer)

Not Viewed

Update (Synchronize) MySQL database schema & Model

Not Viewed

Starting with Virtual Forms & Microsoft Excel VBA

About Virtual Forms for Excel VBA

Not Viewed

Downloading & Installing Virtual Forms Framework for Excel VBA

Not Viewed

Setup your Project Files & Folders

Not Viewed

Creating a menu Userform in Excel VBA

Excel Developer Tab

In Progress

Creating a MainMenu Userform in Excel VBA

Not Viewed

Adding first few lines of Excel VBA code

Adding a reference to the Virtual Form control in Excel VBA

Not Viewed

Creating a public instance of the Virtual Form control object in Excel VBA

Not Viewed

Writing Initialization and termination code in Excel VBA

Not Viewed

Troubleshooting connecting to MySQL in VBA

Not Viewed

Tip: Error "Class does not support Automation or does not support expected inter

Not Viewed

Creating our first Virtual Forms with Virtual Forms Designer for Excel VBA

Excel VBA code for opening the Virtual Form Designer

Not Viewed

Explaining the Virtual Form parts (structure)

Not Viewed

Create your first Virtual Form with VF Designer for Excel

Not Viewed

Tip: Why use Primary Key with Auto Increment

Not Viewed

Creating more Virtual Forms and opening them from Excel VBA

Not Viewed

Tip: "I call the ShowVirtualForm function and nothing happens"

Not Viewed

Customizing Virtual Forms with Virtual Forms Designer for Excel

Change the Virtual Form caption and label captions

Not Viewed

Change the decimal places

Not Viewed

Maximum Length & Width of the Edit & Grid Field

Not Viewed

Intro to Lookup Virtual Forms

Create a simple Lookup Virtual Form

Not Viewed

Search for MySQL Database hosting

Section Introduction

Not Viewed

What do we need for our database

Not Viewed

Choosing the right hosting provider

Not Viewed

Passive income through a web hosting affiliate program

Section Introduction

Not Viewed

What is affiliate marketing in few simple words

Not Viewed

Setting up MySQL server and database on a shared hosting

Section Introduction

Not Viewed

Creating an account with your web hosting provider

Not Viewed

Creating a MySQL database on a shared hosting server

Not Viewed

Export your database to MySQL server on Shared Hosting using Forward Engineering

Not Viewed

Differences between Windows & Linux related to the MySQL server

Not Viewed

Using hosted database within Excel VBA & Virtual Forms

Changing connection string from local to hosted MySQL database in Excel VBA

Not Viewed

From Excel VBA to VB.NET or C# Intro

From Excel VBA to VB.NET

Not Viewed

Creating Customers table and Virtual Form

Creating a Customers table using a SQL script

Not Viewed

Create a Customers Virtual Form in Virtual Forms Designer

Not Viewed

Add Customers Virtual Form to Main Menu Userform in Excel VBA

Not Viewed

Virtual Foms Grid control design change

Grid control change the order of columns

Not Viewed

Grid control change the width of columns

Not Viewed

Grid control initial sort field

Not Viewed

Grid control hide column

Not Viewed

Grid control change the Alignment of the grid column

Not Viewed

Virtual Foms Edit control design change

Virtual Forms partially responsive design

Not Viewed

Edit control change the Tab order of Textboxes

Not Viewed

Edit control change position of Textboxes

Not Viewed

Edit control change the Tab order of Textboxes 1

Not Viewed

Edit control responsive design after repositioning of Textboxes

Not Viewed

Edit control reset the positions of Textboxes

Not Viewed

MySQL Data Export, Import and Generating Dummy data

MySQL Data Export and Import

Not Viewed

MySQL Data Export and Import Experiment

Not Viewed

Generate MySQL dummy (test) data scripts

Not Viewed

Truncate Tables (Delete all the records)

Not Viewed

Inserting dummy (test) data to MySQL

Not Viewed

Dummy data from Virtual Forms

Not Viewed

Access database & Excel Workbook as Data source (Using Blank Templates)

Access database as the Data source (Using Blank Templates)

Not Viewed

Excel workbook as the Data source (Using Blank Templates)

Not Viewed

Events

Getting started with Events

Not Viewed

Events - TextBoxInit

Not Viewed

Relationships

Create MySQL tables Orders, OrderItems & OrderPayments

Not Viewed

Master Detail Virtual Form

Not Viewed

Buttons

Change the Buttons caption

Not Viewed

Custom Buttons Group & Custom Button

Not Viewed

Get data from Database on Button click

Not Viewed

Questions and Answers (Q&A)

Grid Control - Summing

Not Viewed

This is not the END

See us in the next lesson

Not Viewed

Teacher

Davor Geci

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, Google Analytics, 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 Telemetry (connect VBA & Google Analytics or (and) Microsoft Azure Application Insights)