Have Questions? 
help@excelvbaisfun.com
Excel Ninja Pro
All Access

Recent Posts

Save Time and Money with Excel VBA Is Fun tips and tricks!

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

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

New ActiveX Controls - TabStrip (2 Methods)

New ActiveX Controls - TabStrip (2 Methods)

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

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

Customizing Tab Order (3 Ways)

Customizing Tab Order (3 Ways)

Basic Data Entry Userform Pt 2

Basic Data Entry Userform Pt 2

Basic Data Entry Userform Pt 1

Basic Data Entry Userform Pt 1

UserForm Properties Explanation Pt2

UserForm Properties Explanation Pt2

UserForm Properties Explanation Pt1

UserForm Properties Explanation Pt1

Initialize Event

Initialize Event

Modal vs Modeless Forms

Modal vs Modeless Forms

Show, Hide and Unload Userforms

Show, Hide and Unload Userforms

Userforms Part I Overview (Plus Download Kit)

Userforms Overview

A Note On Third Party Enhanced Amazing ActiveX Controls

A Note On Third Party Enhanced Amazing ActiveX Controls

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

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

Toggle Button Basics and Load Webpage On Image Banner Ad Click

Toggle Button Basics and Load Webpage On Image Banner Ad Click

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

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

ScrollBar Control On A Worksheet And Lookup Practice

ScrollBar Control On A Worksheet And Lookup Practice

Make and Utilize INVISIBLE Columns - Special Trick (ActiveX)

Make and Utilize INVISIBLE Columns - Special Trick (ActiveX)

Creating Headers For Your ListBox Creatively

Creating Headers For Your ListBox Creatively

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

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

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

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

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

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

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

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

ListBox Basics and Properties Overview (ActiveX and Form Control)

ListBox Basics and Properties Overview (ActiveX and Form Control)

Adding Customized Multiple Columns Using .AddItem Method (ActiveX)

Adding Customized Multiple Columns Using .AddItem Method (ActiveX)

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

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

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

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

Intro To Form Control ComboBoxes, Index Function

Intro To Form Control ComboBoxes, Index Function

Intro To ComboBoxes, Dropdowns and Properties - Updating a List

Intro To ComboBoxes, Dropdowns and Properties - Updating a List

ActiveX Labels Pt 2

ActiveX Labels Pt 2

Four Neat Uses for ActiveX Labels

Four Neat Uses for ActiveX Labels

SpinButton with Dates in a Textbox

SpinButton with Dates in a Textbox

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

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

SpinButtons with Textboxes and Numbers

SpinButtons with Textboxes and Numbers

Intro to SpinButtons (ActiveX and Form Control)

Intro to SpinButtons (ActiveX and Form Control)

Compliance Checking With Dynamic Button Visibility and Bonus OB Exercise

Compliance Checking With Dynamic Button Visibility and Bonus OB Exercise

Homemade Quiz using Option Buttons, CommandButton and Compliance Checking

Homemade Quiz using Option Buttons, CommandButton and Compliance Checking

OptionButton Overview, Grouping and Alignment

OptionButton Overview, Grouping and Alignment

TripleState and LinkedCell Properties with a Checkbox

TripleState and LinkedCell Properties with a Checkbox

Automating Report Options With A Checkbox

Automating Report Options With A Checkbox

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

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

Ensure User Input Exercise (ActiveX Solution for PC)

Ensure User Input Exercise (ActiveX Solution for PC)

Ensure User Input Exercise (Overview)

Ensure User Input Exercise (Overview)

Selecting All Text When Receiving Focus

Selecting All Text When Receiving Focus

GotFocus and LostFocus Events

GotFocus and LostFocus Events

Restrict User Input With KeyDown Event

Restrict User Input With KeyDown Event

Controlling Tab Order With Worksheet ActiveX Controls

Controlling Tab Order With Worksheet ActiveX Controls

TextBox Change() Event Pt 2

TextBox Change() Event Pt 2

TextBox Change() Event and Tips

TextBox Change() Event and Tips

TextBox Shapes as Form Controls

TextBox Shapes as Form Controls

TextBox Properties Overview (ActiveX)

TextBox Properties Overview (ActiveX)

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

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

Simulating a MouseLeave Like Event with an Invisible Label

Simulating a MouseLeave Like Event with an Invisible Label

Manipulate Worksheet Form Control Label Text (PC,Mac)

Manipulate Worksheet Form Control Label Text (PC,Mac)

MouseMove Event and Using Statusbar for Notifications

MouseMove Event and Using Statusbar for Notifications

KeyPress Event on a CommandButton

KeyPress Event on a CommandButton

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

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

KeyDown Event

KeyDown Event

Intro to ActiveX Key-Press Listeners

Intro to ActiveX Key-Press Listeners

Populate Calendar Project - Solution Pt 2

Populate Calendar Project - Solution Pt 2

1 3 4 5 6 7 14

Excel VBA Is Fun

We believe Excel is one of the most versatile programs out there - and learning to program and automate it makes you very valuable!

You can prevent wasted time and errors, speed up tasks and become indispensable to your organization. 

See how our trainees have gotten raises, promotions and bonuses using their Excel Automation skills while building real problem-solving programs in Excel!
LEARN MORE
Copyright © 2024 ExcelVbaIsFun
X

Forgot Password?

Join Us

0
    0
    Your Cart
    Your cart is emptyReturn to Shop
    linkedin facebook pinterest youtube rss twitter instagram facebook-blank rss-blank linkedin-blank pinterest youtube twitter instagram