Browsing Tag


Excel – Force Uppercase Text in a Column

Forcing uppercase text in a column is sometimes useful if multiple users work on the same file and you want to make this condition by default. Either show an error when they don't insert UPPERCASE text, either make the text UPPERCASE regardless of how they enter it.

Excel – Create a PERSONAL.XLSB File to Store Macros

If you are using Excel VBA you might know this already. Storing macros that work in any Excel file can be done in 2 ways: Creating a macro enabled binary file (PERSONAL.XLSB) that loads when you open any Excel file. Normally Excel doesn't create that file. Creating an Excel add-in (.XLAM, .XLA for older Excel). This is good when you want to personalize existing Ribbons or create a special Ribbon for yourself. In this tutorial we are going to cover the first way since it's the easiest. I might cover the 2nd in…

Create Excel Price Alert E-mail Notification

This is going to be a pretty long and probably a bit intimidating tutorial, I know, but it pays off if it's helpful to you. I've been meaning to buy a mouse from a local e-commerce platform. The mouse isn't expensive but I'd love to get it at a cheaper price, so I need to check for my mouse price daily and decide when to buy it. Amazon sells it 10$ cheaper than this e-commerce site. Why check the price daily (manually) when I can have Excel do that? It can register prices daily in a table, compare last 2 entries…