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

Recent Posts

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

06 - 08 Getting A Taste For Grid Events - Auto Collapse Grouped Items

06 - 07 Grouping With An ADOR Recordset Dynamically

06 - 06 Simulated Grouping Versus True Groups (Code Example)

06 - 05 Filter Bar Hierarchy Inclusion Options

06 - 04 Creating Divider Lines

06 - 03 Making Items Unsortable

06 - 02 Various Lines and Styles For Child Items and Cells

06 - 01 Intro To Group and Aggregate - Hierarchy, Adding Sub Items

04 - Data Entry - How Can I Make Sure Dates Don't Re-Format As TEXT

03 - Data Entry - How Can I Update Gridlines Only To Current Record

02 - Data Entry - Should I put Default values in empty cells

01 - Webscraping Tools - OfficeScripts vs PowerAutomate vs Selenium

03 - Icons, Cursors and Image Tricks, Tips and Hacks

02 - How To Perform Math Operations In A TextBox Like A Cell

01 - Convert Text Numbers to True Numbers VBA Trick

03 - Website Automation With Excel and Selenium

02 - Update Powerpoint Data With Today's Date Using VBA

01 - Search A ListBox and Select Items Programmatically

Custom Function To Determine If Expiry Date Is Expired

Custom Function To Determine If Expiry Date Is Expired

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

05 - Free Stuff and Bonus Questions From Comments

04 - Find, Zoom To and Read Today's Reading of the Day

03 - Beyond Data Validation... Force Cell Input To 'dd MMM yyyy'

02 - Sending an Excel PivotTable using Microsoft Outlook

01 - Introduction

Determining Whether Filters Are Applied And Getting Number of Visible Items

Allowing Case-Sensitivity and Other Filter Bar Prompt Options

Using Filter Bar Prompt Programmatically (2 Methods)

Specifying Columns To Be Used When Filtering With Filter Bar Prompt

Enabling The Filter Bar Prompt

Setting The Column Dropdown Filter's BackColor

Removing Or Customizing Description for Special Items in Column Filter

Using Custom Filter Descriptions In Column Filters

Setting Custom Captions for the FilterBar

Hiding the Filter Bar Description

Turning Off Filter Pattern For a Column

Remove All Items From Drop Down Filter So Only Pattern Search

Exclude Items From A Column Programmatically

Allow Excluding Items In Column Filter

Sorting Items In The Drop Down Column Filter List

Additional Column Filter Features and Customizations with FilterList Property

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

Filter Column Data Immediately As You Type - Incremental Search

Filtering Checked or Unchecked Items

Filtering By Images

Using Filter Patterns

Numeric Filters and Mathematic Operators

How To Display Calendar Control For Date Filter

Date Filter Patterns

Column FilterTypes - Introduction

Programmatically Filtering

Displaying a Column Filter Button

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

Making A Custom Function For Image Lookup

Using VLookup To Grab Any Images By 'Key' Nickname

Using Def and Background Properties To Change Ultra Specific Properties

Manipulating The Color and Transparency Of All EBN Skins At Once

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

Using Visual Design Property To Update Grid Skins and Colors

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

EBN Skin and Grid Customizer Walkthrough (VisualDesigner)

Built-In Visual Themes

ExHelper Amazing FREE Tool and How To Use Help Files

HTML Cheat Sheet - ValueFormat Enumerations PDF Walkthrough

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

Extracting Your Current Template (2 Ways)

Using Template Files For Instant Grid Setup

Load and Make Grid Changes Super Quickly

Multiple Images In A Cell Or Column Header Using HTML

Adding Pictures To Grid Cells

Adding Icon Images To Column Headers

Using and Loading Icon Lists

Adding Icon From Cell Value

Using Icons and Icon Sets From Encoded String or File

ExImages Free Tool Intro

Using Unsortable Items

Getting Sort Positions Programmatically

Programmatically Sorting

All About The Sort Bar

Restrict Certain Changes with Cell Validation

Detect Changed Items and Their Values

Detect Changed Items and Their Values

Sorting By Single or Multiple Column

Using Numeric, Date or Time Type Sorting On Certain Columns

Enable or Disable Standard Sorting On Certain Columns or At All

Mark Edited Cells As Red On Our Grid

Send Grid Edits Back To Excel Sheet

Send Grid Edits Back To Excel Sheet

Enabling Cell Edit Modes - String, Calculator and DatePicker

Enabling Cell Edit Modes - String, Calculator and DatePicker

Adding Hidden Excel Row Identifiers

Adding Hidden Excel Row Identifiers

Adding Rows from Excel Sheet

Adding Rows from Excel Sheet

Adding Rows With Multiple Columns Using Item ID (HITEM)

Adding Rows With Multiple Columns Using Item ID (HITEM)

Adding Multiple Columns

Adding Multiple Columns

Adding a New Item (aka Row)

Adding a New Item (aka Row)

Making A Column and Assigning Column Caption

Making A Column and Assigning Column Caption

Grids on Worksheets vs On A Userform

Grids on Worksheets vs On A Userform

Installing Grid (Demo vs Full)

Installing Grid (Demo vs Full)

Introduction and Course Download Kit

Introduction and Chapter 01 Download Kit

Creating a Simple Self-Extracting Installer Package

Installing PaquetBuilder

Introduction and Course Download Kit

Intro and Course Files Download

Intro and Course Files Download

Automatically Find Buried Folder Recursively - Custom Function

Accessing Important Hidden Collections & Putting Into ComboBoxes

Send Email To Selected Userform ListBox Contact!

Edit Contact Selection From Userform ListBox

Fill Userform ListBox With Outlook Contacts

Iterate Through Contacts and Put Them In Excel Sheet!

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