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

08 Excel VBA ActiveX & Worksheet Form Controls

Current Status

Not Enrolled

Price

$99.00

Get Started

Course Content

Worksheet Controls
Intro To Controls (Plus Download Kit)
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
KeyDown Event
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
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
Intro to SpinButtons (ActiveX and Form Control)
SpinButtons with Textboxes and Numbers
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
Adding Customized Multiple Columns Using .AddItem Method (ActiveX)
ListBox Basics and Properties Overview (ActiveX and Form Control)
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

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 © 2025 ExcelVbaIsFun
X

Forgot Password?

Join Us

linkedin facebook pinterest youtube rss twitter instagram facebook-blank rss-blank linkedin-blank pinterest youtube twitter instagram