Linking Dynamic Array Formulas into Chart Series With the introduction of Dynamic Array functions in Excel, your spreadsheets can now...
Parts Of A Ribbon Button’s Tool Tip Programatically, there are two parts to a button’s tool tip box that appears...
I’ve had quite a few IT administrators request that I provide an MSI Installer file (often referred to as a...
What This VBA Code Does There may be times when you need to refresh the user interface (UI) of your...
I’ve run into this issue numerous times and I just figured out how to prevent the dreaded error message from...
Why Is This Happening? This year (July 2016) Microsoft decided to heighten its security features and block files that are...
What This VBA Code Does There may be times when you want to incorporate code from your add-ins into other...
Why Center Across? I am a huge advocate for using the Excel functionality of Center Across Selection instead of Merge...
One of the most prosperous skills I have picked up over the years as a financial analyst has been the...
Installing Your Excel Add-in1. Ensure Your Excel Add-in File Is Unblocked2. Save Your Excel Add-in File To Your Computer3. Enable...
Where Did My Code Go? That was the question I was asking myself when I first began to create PowerPoint...