Join the Newsletter Product Help
Search
×
Excel VBA About Shop
light graph cubes

Be The Expert
In Your Office

Popular Products

See all products →
Tickmark Auditing Add-in
Tickmark Auditing Add-in

Insert tickmark symbols, hyperlink steps, audit how models are structured, and much more!

Learn More >>
E2P
E2P

Automate copy & pasting from Excel to your PowerPoint slides with one click!

Learn More >>
My First Add-in
My First Add-in

This template allows you to easily create your own Ribbon-based macro add-in

Learn More >>
My Brand
My Brand

Add your company or personal brand colors & logo images to the Excel Ribbon as buttons

Learn More >>

Master Excel

See all Excel guides →
7 Ways To Generate Unique Values List In Excel
7 Ways To Generate Unique Values List In Excel

There are many scenarios you may come across while working in Excel where you only desire unique val...
Determine YTD Stock Growth With Excel's STOCKHISTORY Function
Determine YTD Stock Growth With Excel's STOCKHISTORY Function

Learn how you can utilize Excel’s stock functions to calculate changes in price between two points...
Printable Blank Calendar Templates For 2023
Printable Blank Calendar Templates For 2023

A spreadsheet calendar in Microsoft Excel can be a helpful tool for managing and organizing schedul...
How To Disable (Turn Off) Excel 2013's In-Window Animations
How To Disable (Turn Off) Excel 2013's In-Window Animations

When I first played around with Excel 2013 the new navigation animations were one of the first thing...
Microsoft Office 2023 Theme Color Update
Microsoft Office 2023 Theme Color Update

Explore Microsoft Office's 2023 color theme update, designed with a focus on accessibility and user ...
My Excel Columns Or Rows Not Hidden But Missing?!
My Excel Columns Or Rows Not Hidden But Missing?!

Learn about this obscure spreadsheet feature that makes it impossible to view/access rows or columns...

Master VBA

See all VBA guides →
The VBA Guide For Using Userform ListBox Controls
The VBA Guide For Using Userform ListBox Controls

This guide will provide you with all the critical VBA snippets you’ll need to know in order to int...
How To View PowerPoint Add-in VBA Code Inside Visual Basic Editor
How To View PowerPoint Add-in VBA Code Inside Visual Basic Editor

Is your PowerPoint VBA code not showing up in your Visual Basic Editor? Learn how you can easily mod...
Loop Through All Form Control Checkboxes On Excel Spreadsheet
Loop Through All Form Control Checkboxes On Excel Spreadsheet

This code will loop through each of your Form Control checkboxes and let you 'do something' based on...
VBA Code to Lighten or Darken Fill Colors in Excel
VBA Code to Lighten or Darken Fill Colors in Excel

I've been on a mission the past two weeks to craft a pair of macros to lighten and dark a cell fill ...
VBA Copy/Paste An Image, Text, & Table (Excel to Word)
VBA Copy/Paste An Image, Text, & Table (Excel to Word)

Learn how to export text, tables, logo images from Excel to Microsoft Word automatically with VBA ma...
Bold The Last Word Of Text In A Cell
Bold The Last Word Of Text In A Cell

This bit of VBA code looks at a string within a specified cell and bolds the last word in the cell t...

Fresh Off The Sheet

US Accounting Audit Sample Data for Excel Practice [Instant Download]
US Accounting Audit Sample Data for Excel Practice [Instant Download]

Download a professional US accounting audit dataset for Excel practice. 500 rows of GAAP-compliant d...
Ohio EdChoice Scholarship Calculator: Estimate Your Private School Voucher
Ohio EdChoice Scholarship Calculator: Estimate Your Private School Voucher

Estimate your Ohio EdChoice scholarship amount for 2025–2026 with this free calculator. Enter your...
How to Use or Mimic Dark Mode in Microsoft Excel (Complete Guide)
How to Use or Mimic Dark Mode in Microsoft Excel (Complete Guide)

Changing To The Dark...
Calculate Quarter & FY Totals With Single Excel Function
Calculate Quarter & FY Totals With Single Excel Function

Learn how to write a custom Excel function that will output both Quarter and Full Year calculations ...
Add Your Lambda Functions with VBA Macro Code
Add Your Lambda Functions with VBA Macro Code

Learn how to use VBA code to import all your Lambda Functions into the ActiveWorkbook
All of Excel's Dynamic Array Functions
All of Excel's Dynamic Array Functions

A comprehensive list of all available Dynamic Array functions in Microsoft Excel
Formula to Split Excel Data into Multiple Excel Tabs (No VBA)
Formula to Split Excel Data into Multiple Excel Tabs (No VBA)

Microsoft Excel MVP Chris Newman shows you how to divide a data table into individual tabs using jus...
Does Cell Contain Upper Or Lower Case Character Formula
Does Cell Contain Upper Or Lower Case Character Formula

Microsoft Excel MVP Chris Newman provides you with formulas to identify text containing either capit...
Quickly Create A Dynamic Named Range in Excel
Quickly Create A Dynamic Named Range in Excel

Discover how to leverage dynamic Named Ranges in Excel for automatic updates and improved efficiency...
10 Essential Excel Shortcuts for Busy Professionals!
10 Essential Excel Shortcuts for Busy Professionals!

Discover the top 10 Excel shortcuts to boost your productivity, speed, and efficiency. Master these ...
List Duplicates or Missing Values By Comparing Two Columns In Excel
List Duplicates or Missing Values By Comparing Two Columns In Excel

Microsoft Excel MVP Chris Newman showcases how you can write formulas to compare two lists of cells ...
Excel Formula To Find Any Special Character
Excel Formula To Find Any Special Character

Discover how to identify special characters in Excel cells with this comprehensive guide. Learn to c...