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

Best Way To Paste Special Excel Objects As PowerPoint Images

Best Way To Paste Special Excel Objects As PowerPoint Images

I've written many times in the past on how the quality and formatting of your work can separate you from the rest of the pack when creating presentations. Our cultural is becoming more and more focused on graphic design and it has been proven to increase your audience's ability to understand the data you are presenting. 

Read More