The Ultimate Excel VBA Course 2.0

Workbook Open and Environ Function

Useful Workbook-Level Commands - Opening, Saving and Closing

Login Program - Objectives Overview

Login Program - Solution

Workbook Activate Event

Workbook BeforeSave Event

Workbook AfterSave Event - Make Backup Copy Upon Successful Save

BeforeClose and BeforePrint Events

Workbook Deactivate Event

Exercise 09 - Objectives Overview

Exercise 09 - Solution

SheetActivate Event - 3 Ways to Specify Which Sheets To Trigger Macro

SheetDeactivate Event

Comparing Workbook to Worksheet Events, Delete, Double-click, Right-click, Calcu

PivotTable Auto Update Exercise - Objectives Overview

PivotTable Auto Update Exercise - Solution

WindowActivate and WindowDeactivate - Windows vs Workbooks vs Sheets

WindowResize Event - Force A Minimum Width For Your App

Worksheet Controls

Intro To Controls

CommandButtons on Windows and Mac - Wage Calculator

Adding An Image and Formatting Button (ActiveX and Form)

CommandButton Properties Overview (ActiveX and Form)

Populate Calendar Project - Objectives Overview

Populate Calendar Project - Solution Pt 1

Populate Calendar Project - Solution Pt 2

Intro to ActiveX Key-Press Listeners

Capturing Shift, Alt, Ctrl (or some combination) Using the Shift Variable

KeyPress Event on a CommandButton

MouseMove Event and Using Statusbar for Notifications

Manipulate Worksheet Form Control Label Text (PC,Mac)

Simulating a MouseLeave Like Event with an Invisible Label

MouseUp and MouseDown Events - Left, Middle, and Rightclick, Shift, Alt and Ctrl

TextBox Properties Overview (ActiveX)

TextBox Shapes as Form Controls

TextBox Change() Event and Tips

TextBox Change() Event Pt 2

Controlling Tab Order With Worksheet ActiveX Controls

Restrict User Input With KeyDown Event

GotFocus and LostFocus Events

Selecting All Text When Receiving Focus

Ensure User Input Exercise (Overview)

Ensure User Input Exercise (ActiveX Solution for PC)

Ensure User Input Exercise (Form Control Solution for Mac,PC)

Automating Report Options With A Checkbox

TripleState and LinkedCell Properties with a Checkbox

OptionButton Overview, Grouping and Alignment

Homemade Quiz using Option Buttons, CommandButton and Compliance Checking

Compliance Checking With Dynamic Button Visibility and Bonus OB Exercise

Intro to SpinButtons (ActiveX and Form Control)

SpinButtons with Textboxes and Numbers

SpinButton - Changing Size, Position and Other Properties, Not Just Value

SpinButton with Dates in a Textbox

Four Neat Uses for ActiveX Labels

ActiveX Labels Pt 2

Intro To ComboBoxes, Dropdowns and Properties - Updating a List

Intro To Form Control ComboBoxes, Index Function

Two Methods For Dynamic Ranges For Your Lists (ActiveX and Form ComboBox)

Get Specific Items in Your Combobox List, Clear All (ActiveX and Form Control)

Adding Customized Multiple Columns Using .AddItem Method (ActiveX)

ListBox Basics and Properties Overview (ActiveX and Form Control)

ListBox Practice: Dynamic Cell Manipulation, ListIndex, List (ActiveX & Form)

Additional Ways To Fill A List Quickly, Remove & Change Entries (ActiveX & Form)

Using and Manipulating MultiSelect Items in a Listbox (ActiveX and Form)

Dynamic ListBoxes Using .ADDITEM and More (ActiveX and Form Controls)

Creating Headers For Your ListBox Creatively

Make and Utilize INVISIBLE Columns - Special Trick (ActiveX)

ScrollBar Control On A Worksheet And Lookup Practice

Image Control - 2 Ways to Assign a Picture (ActiveX)

Toggle Button Basics and Load Webpage On Image Banner Ad Click

Inserting a Shape Object as Picture and Why Not To Use Pictures.Insert

A Note On Third Party Enhanced Amazing ActiveX Controls

Userforms - the best thing. EVER.

Userforms Overview

Show, Hide and Unload Userforms Sample Lesson

Modal vs Modeless Forms

Initialize Event

UserForm Properties Explanation Pt1

UserForm Properties Explanation Pt2

Basic Data Entry Userform Pt 1

Basic Data Entry Userform Pt 2

Customizing Tab Order (3 Ways)

Image Secrets To Make Pictures Look Great (Using Enhanced Metafiles)

New ActiveX Controls - TabStrip (2 Methods)

New ActiveX Controls - MultiPage (Make A 'Wizard' Tool)

New ActiveX Controls - MultiPage - Backcolors and Color Workaround

New ActiveX Controls - Frame

Centering A Userform On A Window (Even With Multiple Monitors)

Conversion Userform Tool Exercise - Objectives Overview

Conversion Userform Tool Exercise - Solutions Video

Data Entry In Excel vs Access Or Other Sources

Data Entry Userform Project - Employee Form Setup Tab 1

Data Entry Userform Project - Filling ComboBoxes and Planning (2 Ways)

Data Entry Userform Project - Adding A 'Save New' Button For 'Personal' Tab

Data Entry Userform Project - Get Next Available Employee ID Custom Function (UDF)

Data Entry Userform Project - Tab Order and Data Cleanup Tricks

Data Entry Userform Project - Set Up Employment Tab and Planning

Data Entry Userform Project - Coding Employment Tab and Automation

Data Entry Userform Project - Resetting The Form Upon Submission

Data Entry Userform Project - Adding User Photos and Using GetOpenFilePath() Fun

Data Entry Userform Project - Creating A Function To Validate Required Fields

Edit Mode for Employee Database - Part 1

Edit Mode for Employee Database - Part 2 - Custom Function to Find Row of Emp ID

Edit Mode for Employee Database - Part 3 - Loading The Form Based On Selection

Edit Mode for Employee DataSet - Part 4 - Load & Select ListBox Entry from Data

Edit Mode for Employee DataSet - Part 5 - Load Picture From DataSet File Name

Edit Mode Part 6 - Switch Search Mode To ID, Name, LastName, etc

Edit Mode for Employee DataSet - Part 7 - Saving Existing Records In Edit Mode

Troubleshooting Tips For ListBox With Empty String

Refreshing the Rowsource After Updating Data On Dynamic ComboBoxes

UserForm Final Cleanup and Tips

Easy Way To Copy A UserForm or Module (2 Methods)

Advanced MultiColumn Search Tools - Custom Lookup by Name, ID, and More!

How Usernames and Passwords Work - Encryption, Hashing, Salt Basics

Log In Program Exercise 2.0 - Userform With UserName and Password (Overview)

Log In Program Exercise 2.0 - Solution

Userform Employee Report - Set Up Dynamic Column Variables (Easy Hack)

Applying Dynamic Custom Filters To Reports (2 Ways)

Offering Users Different Sort Options For Reporting

Report Generation and Aesthetics, Headers, Footers, Repeat Rows etc

Programmatically Update Page Headers and Footers - Plus Special Formatting Code

Alternating Row Colors or Lines Using Conditional Formatting (Zebra)

EEOC Report For Employee Stats (VBA Efficiency Tricks)

Advanced Exercise - Objectives Overview

Advanced Exercise 01 - Solution

Advanced Exercise 02 - Solution

Advanced Exercise 03 and 04 - Solutions

Advanced Exercise BONUS A and B - Solutions

Advanced Exercise BONUS C Automate the Workflow for Efficiency - Solutions

Concluding Thoughts. . .

BONUS Section - VBA Functions

InStr Function - Search for Text Within Other Text

The EVALUATE Function - Mac-Daddy of all functions

Sum Function in Excel VBA - EASY!

Count Function in VBA

2 of 2

Previous Lesson

Show, Hide and Unload Userforms

The Ultimate Excel VBA Course 2.0
Show, Hide and Unload Userforms

Previous Lesson

Leave a Comment Click here to cancel reply.

You must be logged in to post a comment.

X

Username

Password

Remember me

Forgot Password?

Login

Accessing this course requires a login. Please enter your credentials below!

Username or Email Address

Password

Remember Me

Lost Your Password?

Register

Don't have an account? Register one!

Register an Account