Correcting Shape Assigned Macro Links After Copying Worksheet VBA

Correcting Shape Assigned Macro Links After Copying Worksheet VBA

The easiest way to copy over VBA code while copying your worksheets into a new workbook is to store your VBA macros within the worksheet itself instead of the typical Modules that most people use. While it is possible to copy Modules from one workbook to another, it adds another layer of VBA coding that is much more of a hassle than storing your code within a Worksheet Object.

Read More

Adding Tickmark Indicators To Your Excel Analysis Comments

Adding Tickmark Indicators To Your Excel Analysis Comments

Today, I am going to show you how to easily add indicators to your commentary so your audience (ie the decision-makers) already has the right state of mind before reading a single letter of your comments. This will tremendously help them comprehend your analysis and score you "brownie points", because they will be able to do it in a fraction of the time as well!

Read More

Excel PowerBall Lottery Ticket Checker Spreadsheet

Excel PowerBall Lottery Ticket Checker Spreadsheet

With this Excel-powered spreadsheet you can type in all your lottery ticket picks and automatically get fed winning numbers once the lottery balls have been picked. I'll provide a little bit of how the spreadsheet is setup and then you can download this Excel file for free and use it to analyze the next time your office pulls together $500 bucks for a chance at living the good life.

Read More

Masking (Hiding) A Password As It Is Entered In An Excel Text Box

Masking (Hiding) A Password As It Is Entered In An Excel Text Box

Today, I came across a spreadsheet that allowed a user to connect to a remote database via VBA. The spreadsheet had a nifty little interface allowing you to enter your username and password for access to the database. The thing that caught my eye was the password had masked characters, so no one passing by your desk could see your password.

Read More

How To Trigger Your VBA Macros To Run Based On A Specific Cell Value Change

How To Trigger Your VBA Macros To Run Based On A Specific Cell Value Change

Today we are going to discuss how you can automatically make your VBA code execute based on a specific cell value being changed. Behind the scenes, Excel keeps track of specific events that occur while the user is working on their spreadsheet. These tracked events are called Event Handlers and we can use Event Handlers as triggers to kick off our macros based on what our users are doing to their spreadsheets.

Read More

Using Cell Formatting Logic With Excel Formulas

Using Cell Formatting Logic With Excel Formulas

Have you ever had a time where you wished you could write an IF formula in Excel based on whether or not a cell was filled with the color green or not? Unfortunately, Excel doesn't have a built-in "IsGreen" function you can call to perform such logic. However, with the power of VBA you can write your own functions and actually call them from the Formula Bar! 

Read More

Easy Step-By-Step Instructions To Create Your First Excel Ribbon Add-in

Easy Step-By-Step Instructions To Create Your First Excel Ribbon Add-in

One of the most prosperous skills I have picked up over the years as a financial analyst has been the ability to create custom Excel add-ins specific to my department and company's needs. This one skill I have been able to provide to my company has saved numerous people time, frustration, and money. While it took me well over a year to teach myself how to create top-notch add-ins, I want to let you in on a little secret....it's really NOT THAT HARD! 

Read More