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

Advanced Grid Controls In Excel VBA with ExGrid

Current Status

Not Enrolled

Price

$135.00

Get Started

Course Content

01 - The Basics
Introduction and Course Download Kit
Installing Grid (Demo vs Full)
Grids on Worksheets vs On A Userform
02 - Creating Your First Grid
Making A Column and Assigning Column Caption
Adding a New Item (aka Row)
Adding Multiple Columns
Adding Rows With Multiple Columns Using Item ID (HITEM)
Adding Rows from Excel Sheet
Adding Hidden Excel Row Identifiers
Enabling Cell Edit Modes - String, Calculator and DatePicker
Detect Changed Items and Their Values
Send Grid Edits Back To Excel Sheet
Mark Edited Cells As Red On Our Grid
03 - Sorting and Filtering
Restrict Certain Changes with Cell Validation
Enable or Disable Standard Sorting On Certain Columns or At All
Using Numeric, Date or Time Type Sorting On Certain Columns
Sorting By Single or Multiple Column
All About The Sort Bar
Programmatically Sorting
Getting Sort Positions Programmatically
04 - Images and Formatting
Using Unsortable Items
ExImages Free Tool Intro
Using Icons and Icon Sets From Encoded String or File
Adding Icon From Cell Value
Using and Loading Icon Lists
Adding Icon Images To Column Headers
Adding Pictures To Grid Cells
Multiple Images In A Cell Or Column Header Using HTML
Load and Make Grid Changes Super Quickly
Using Template Files For Instant Grid Setup
Extracting Your Current Template (2 Ways)
HTML Cheat Sheet - ValueFormat Enumerations PDF Walkthrough
ExHelper Amazing FREE Tool and How To Use Help Files
Built-In Visual Themes
EBN Skin and Grid Customizer Walkthrough (VisualDesigner)
Using Visual Design Property To Update Grid Skins and Colors
Changing The Color Of An Existing EBN (Skin) File Instantly
Manipulating The Color and Transparency Of All EBN Skins At Once
Using VLookup To Grab Any Images By 'Key' Nickname
Making A Custom Function For Image Lookup
05 - COLUMN FILTERS AND FILTER BAR
How To Get The Base64 String Of Any Image Programmatically From Excel
Displaying a Column Filter Button
Programmatically Filtering
Column FilterTypes - Introduction
Date Filter Patterns
How To Display Calendar Control For Date Filter
Numeric Filters and Mathematic Operators
Using Filter Patterns
Filtering By Images
Filtering Checked or Unchecked Items
Filter Column Data Immediately As You Type - Incremental Search
Sorting Items In The Drop Down Column Filter List
Allow Excluding Items In Column Filter
Exclude Items From A Column Programmatically
Remove All Items From Drop Down Filter So Only Pattern Search
Turning Off Filter Pattern For a Column
Hiding the Filter Bar Description
Setting Custom Captions for the FilterBar
Using Custom Filter Descriptions In Column Filters
Removing Or Customizing Description for Special Items in Column Filter
Setting The Column Dropdown Filter's BackColor
Enabling The Filter Bar Prompt
Specifying Columns To Be Used When Filtering With Filter Bar Prompt
Using Filter Bar Prompt Programmatically (2 Methods)
Allowing Case-Sensitivity and Other Filter Bar Prompt Options
06 - Grouping and Aggregate Functions
06 - 01 Intro To Group and Aggregate - Hierarchy, Adding Sub Items
06 - 02 Various Lines and Styles For Child Items and Cells
06 - 03 Making Items Unsortable
06 - 04 Creating Divider Lines
06 - 05 Filter Bar Hierarchy Inclusion Options
06 - 06 Simulated Grouping Versus True Groups (Code Example)
06 - 07 Grouping With An ADOR Recordset Dynamically
06 - 08 Getting A Taste For Grid Events - Auto Collapse Grouped Items
06 - 09 Disable All Or Certain Columns From Grouping
06 - 10 Grouping Programmatically While Sort Bar Is Hidden
06 - 11 Enabling and Manipulating the Popup Column Picker
06 - 13 Simple SUM With No Child Items
06 - 14 Locked Items On Top Or Bottom Of Grid (FreezePanes)
06 - 15 Code Review - 2 More Examples
06 - 16 Excluding Items From Computation (Plus Expression Syntax 101)
06 - 17 Aggregate Functions Using Index Numbers Instead Of Lists
06 - 18 Formulas Including Immediate If Operator (SumIF in ExGrid)
06 - 19 Computing VAT or Income Taxes In Neighboring Columns
06 - 20 Use Multiplication In Subtotal Calculations
06 - 21 Using Subtotal and Grand Totals Together (Bonus Solutions)
06 - 22 Multiple Totals In A Single Cell (SplitCell Property)
06 - 23 Multiple Totals In A Single Merged Cell
06 - 24 Getting Totals For Each Column At The Bottom
06 - 25 Concatenation Issues And Solutions
06 - 26 Special GroupBy Totals Only When Certain Columns Are Grouped
06 - 28 Auto-Adding New Subtotals to Items When Group Mode Triggered
06 - 29 Min, Max and Sum At The Top For Group Mode

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