Lessons Archive | Excel VBA Is Fun

Generating One Email To An Automated List (To, CC or BCC)

by Dan Strong | Sep 13, 2021 | Uncategorized

05 – Free Stuff and Bonus Questions From Comments

by Dan Strong | Sep 6, 2021 | Uncategorized

04 – Find, Zoom To and Read Today’s Reading of the Day

by Dan Strong | Sep 6, 2021 | Uncategorized

03 – Beyond Data Validation… Force Cell Input To ‘dd MMM yyyy’

by Dan Strong | Sep 6, 2021 | Uncategorized

02 – Sending an Excel PivotTable using Microsoft Outlook

by Dan Strong | Sep 6, 2021 | Uncategorized

01 – Introduction

by Dan Strong | Sep 6, 2021 | Uncategorized

Determining Whether Filters Are Applied And Getting Number of Visible Items

by Dan Strong | Aug 2, 2021 | Uncategorized

Allowing Case-Sensitivity and Other Filter Bar Prompt Options

by Dan Strong | Aug 2, 2021 | Uncategorized

Using Filter Bar Prompt Programmatically (2 Methods)

by Dan Strong | Aug 2, 2021 | Uncategorized

Specifying Columns To Be Used When Filtering With Filter Bar Prompt

by Dan Strong | Aug 2, 2021 | Uncategorized

Enabling The Filter Bar Prompt

by Dan Strong | Aug 2, 2021 | Uncategorized

Setting The Column Dropdown Filter’s BackColor

by Dan Strong | Aug 2, 2021 | Uncategorized

Removing Or Customizing Description for Special Items in Column Filter

by Dan Strong | Aug 2, 2021 | Uncategorized

Using Custom Filter Descriptions In Column Filters

by Dan Strong | Aug 2, 2021 | Uncategorized

Setting Custom Captions for the FilterBar

by Dan Strong | Aug 2, 2021 | Uncategorized

Hiding the Filter Bar Description

by Dan Strong | Aug 2, 2021 | Uncategorized

Turning Off Filter Pattern For a Column

by Dan Strong | Aug 2, 2021 | Uncategorized

Remove All Items From Drop Down Filter So Only Pattern Search

by Dan Strong | Aug 2, 2021 | Uncategorized

Exclude Items From A Column Programmatically

by Dan Strong | Aug 2, 2021 | Uncategorized

Allow Excluding Items In Column Filter

by Dan Strong | Aug 2, 2021 | Uncategorized

Sorting Items In The Drop Down Column Filter List

by Dan Strong | Aug 2, 2021 | Uncategorized

Additional Column Filter Features and Customizations with FilterList Property

by Dan Strong | Aug 2, 2021 | Uncategorized

Change Filter Criteria To Use OR, NOT Operators Instead of AND Operator

by Dan Strong | Aug 2, 2021 | Uncategorized

Filter Column Data Immediately As You Type – Incremental Search

by Dan Strong | Aug 2, 2021 | Uncategorized

Filtering Checked or Unchecked Items

by Dan Strong | Aug 2, 2021 | Uncategorized

Filtering By Images

by Dan Strong | Aug 2, 2021 | Uncategorized

Using Filter Patterns

by Dan Strong | Aug 2, 2021 | Uncategorized

Numeric Filters and Mathematic Operators

by Dan Strong | Aug 2, 2021 | Uncategorized

How To Display Calendar Control For Date Filter

by Dan Strong | Aug 2, 2021 | Uncategorized

Date Filter Patterns

by Dan Strong | Aug 2, 2021 | Uncategorized

Column FilterTypes – Introduction

by Dan Strong | Aug 2, 2021 | Uncategorized

Programmatically Filtering

by Dan Strong | Aug 2, 2021 | Uncategorized

Displaying a Column Filter Button

by Dan Strong | Aug 2, 2021 | Uncategorized

How To Get The Base64 String Of Any Image Programmatically From Excel

by Dan Strong | Jul 14, 2021 | Uncategorized

Making A Custom Function For Image Lookup

by Dan Strong | Jul 14, 2021 | Uncategorized

Using VLookup To Grab Any Images By ‘Key’ Nickname

by Dan Strong | Jul 14, 2021 | Uncategorized

Using Def and Background Properties To Change Ultra Specific Properties

by Dan Strong | Jul 14, 2021 | Uncategorized

Manipulating The Color and Transparency Of All EBN Skins At Once

by Dan Strong | Jul 14, 2021 | Uncategorized

Changing The Color Of An Existing EBN (Skin) File Instantly

by Dan Strong | Jul 14, 2021 | Uncategorized

Using Visual Design Property To Update Grid Skins and Colors

by Dan Strong | Jul 14, 2021 | Uncategorized

Adding EBN Skin Files Into The Grid and Assigning To Specific Parts Of Grid

by Dan Strong | Jul 14, 2021 | Uncategorized

EBN Skin and Grid Customizer Walkthrough (VisualDesigner)

by Dan Strong | Jul 14, 2021 | Uncategorized

Built-In Visual Themes

by Dan Strong | Jul 14, 2021 | Uncategorized

ExHelper Amazing FREE Tool and How To Use Help Files

by Dan Strong | Jul 8, 2021 | Uncategorized

HTML Cheat Sheet – ValueFormat Enumerations PDF Walkthrough

by Dan Strong | Jul 8, 2021 | Uncategorized

Getting Current Layout as String (Column Positions, Scroll Position, Filtering Values)

by Dan Strong | Jul 8, 2021 | Uncategorized

Extracting Your Current Template (2 Ways)

by Dan Strong | Jul 8, 2021 | Uncategorized

Using Template Files For Instant Grid Setup

by Dan Strong | Jul 8, 2021 | Uncategorized

Load and Make Grid Changes Super Quickly

by Dan Strong | Jul 8, 2021 | Uncategorized

Multiple Images In A Cell Or Column Header Using HTML

by Dan Strong | Jul 8, 2021 | Uncategorized

Adding Pictures To Grid Cells

by Dan Strong | Jul 8, 2021 | Uncategorized

Adding Icon Images To Column Headers

by Dan Strong | Jul 8, 2021 | Uncategorized

Using and Loading Icon Lists

by Dan Strong | Jul 8, 2021 | Uncategorized

Adding Icon From Cell Value

by Dan Strong | Jul 8, 2021 | Uncategorized

Using Icons and Icon Sets From Encoded String or File

by Dan Strong | Jul 8, 2021 | Uncategorized

ExImages Free Tool Intro

by Dan Strong | Jul 8, 2021 | Uncategorized

Using Unsortable Items

by Dan Strong | Jul 1, 2021 | Uncategorized

Getting Sort Positions Programmatically

by Dan Strong | Jul 1, 2021 | Uncategorized

Programmatically Sorting

by Dan Strong | Jul 1, 2021 | Uncategorized

All About The Sort Bar

by Dan Strong | Jul 1, 2021 | Uncategorized

Restrict Certain Changes with Cell Validation

by Dan Strong | Jun 21, 2021 | Uncategorized

Detect Changed Items and Their Values

by Dan Strong | Jun 21, 2021 | Uncategorized

Sorting By Single or Multiple Column

by Dan Strong | Jun 16, 2021 | Uncategorized

Using Numeric, Date or Time Type Sorting On Certain Columns

by Dan Strong | Jun 16, 2021 | Uncategorized

Enable or Disable Standard Sorting On Certain Columns or At All

by Dan Strong | Jun 16, 2021 | Uncategorized

Mark Edited Cells As Red On Our Grid

by Dan Strong | Jun 16, 2021 | Uncategorized

Send Grid Edits Back To Excel Sheet

by Dan Strong | Jun 16, 2021 | Uncategorized

Enabling Cell Edit Modes – String, Calculator and DatePicker

by Dan Strong | Jun 16, 2021 | Uncategorized

Adding Hidden Excel Row Identifiers

by Dan Strong | Jun 16, 2021 | Uncategorized

Using hWnd Row Identifiers

by Dan Strong | Jun 16, 2021 | Uncategorized

Adding Rows from Excel Sheet

by Dan Strong | Jun 16, 2021 | Uncategorized

Adding Rows With Multiple Columns Using Item ID (HITEM)

by Dan Strong | Jun 16, 2021 | Uncategorized

Adding Multiple Columns

by Dan Strong | Jun 16, 2021 | Uncategorized

Adding a New Item (aka Row)

by Dan Strong | Jun 16, 2021 | Uncategorized

Making A Column and Assigning Column Caption

by Dan Strong | Jun 16, 2021 | Uncategorized

Grids on Worksheets vs On A Userform

by Dan Strong | Jun 16, 2021 | Uncategorized

Installing Grid (Demo vs Full)

by Dan Strong | Jun 16, 2021 | Uncategorized

Introduction

by Dan Strong | Jun 16, 2021 | Uncategorized

Creating a Simple Self-Extracting Installer Package

by Dan Strong | May 20, 2021 | Uncategorized

Installing PaquetBuilder

by Dan Strong | May 20, 2021 | Uncategorized

Introduction and Course Download Kit

by Dan Strong | May 20, 2021 | Uncategorized

Intro and Course Files Download

by Dan Strong | May 6, 2021 | Uncategorized

Welcome! Please download the course files above in the ‘Materials’ tab. Then watch this video to get started!...