×

VBA Developing Add-ins

Dynamic Array Formula Spill Ranges With Charts

Dynamic Array Formula Spill Ranges With Charts

Linking Dynamic Array Formulas into Chart Series With the introduction of Dynamic Array functions in Excel, your spreadsheets can now...

Add Line Breaks In Screentips & SuperTips (Ribbon XML)

Add Line Breaks In Screentips & SuperTips (Ribbon XML)

Parts Of A Ribbon Button’s Tool Tip Programatically, there are two parts to a button’s tool tip box that appears...

How To Create MSI Auto-Installers For VBA Add-ins

How To Create MSI Auto-Installers For VBA Add-ins

I’ve had quite a few IT administrators request that I provide an MSI Installer file (often referred to as a...

Refresh Ribbon UI  In Your Custom Excel Add-in

Refresh Ribbon UI In Your Custom Excel Add-in

What This VBA Code Does There may be times when you need to refresh the user interface (UI) of your...

How To Prevent The Excel Error Message For A Missing Add-in

How To Prevent The Excel Error Message For A Missing Add-in

I’ve run into this issue numerous times and I just figured out how to prevent the dreaded error message from...

Prevent Microsoft Office Add-ins From Disappearing

Prevent Microsoft Office Add-ins From Disappearing

Why Is This Happening? This year (July 2016) Microsoft decided to heighten its security features and block files that are...

How To Ensure Your Microsoft Office VBA Add-in File Is Installed & Loaded

How To Ensure Your Microsoft Office VBA Add-in File Is Installed & Loaded

What This VBA Code Does There may be times when you want to incorporate code from your add-ins into other...

How To Add A Center Across Selection Button To Excel's Home Ribbon Tab

How To Add A Center Across Selection Button To Excel's Home Ribbon Tab

Why Center Across? I am a huge advocate for using the Excel functionality of Center Across Selection instead of Merge...

Step-By-Step Create Your First Excel Ribbon Add-in (Easily!)

Step-By-Step Create Your First Excel Ribbon Add-in (Easily!)

One of the most prosperous skills I have picked up over the years as a financial analyst has been the...

How to Easily Install/Uninstall Excel VBA Add-in Files

How to Easily Install/Uninstall Excel VBA Add-in Files

Installing Your Excel Add-in1. Ensure Your Excel Add-in File Is Unblocked2. Save Your Excel Add-in File To Your Computer3. Enable...

How To View PowerPoint Add-in VBA Code Inside Visual Basic Editor

How To View PowerPoint Add-in VBA Code Inside Visual Basic Editor

Where Did My Code Go? That was the question I was asking myself when I first began to create PowerPoint...