×

Add-ins

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...

Which Excel Versions Have XLOOKUP Function? [Solved]

Which Excel Versions Have XLOOKUP Function? [Solved]

Versions Of Microsoft Excel For XLOOKUP Function The following versions of Microsoft Excel include the XLOOKUP function: Excel 2021 or...

How To Show The Developer Ribbon Tab [With Pictures]

How To Show The Developer Ribbon Tab [With Pictures]

Steps To Add The Developer Tab In Excel For PCAdd The Developer Tab in Microsoft WordAdd The Developer Tab in...

How To Use VBA Code With Oracle's Smart View Add-in

How To Use VBA Code With Oracle's Smart View Add-in

What Is The Oracle Smart View Add-in? The Smart View Excel Add-in is a free Oracle tool that allows you...

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...

Top Microsoft Excel Add-ins You Should Consider Using

Top Microsoft Excel Add-ins You Should Consider Using

What Are Add-ins? Add-ins for Excel are similar to the apps you can download and purchase for your smartphone. They...

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 Run Personal VBA Macros in Microsoft PowerPoint

How To Run Personal VBA Macros in Microsoft PowerPoint

PowerPoint Is Not Excel! I have spent probably 90% of my Microsoft Office usage inside Excel.  Because of this, I...

Excel QAT Setups From Some Of The Excel Community's Finest

Excel QAT Setups From Some Of The Excel Community's Finest

What's a QAT? QAT is short for Quick Access Toolbar and this bar is typically setup to store frequently used Excel functionalities;...

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...