My Spreadsheet Lab

The site is about Microsoft Excel.

  • Home
  • Templates
  • Excel Blog
  • About Me
  • Contact Kevin

Posts Tagged → vba

Game Review: The Worksheet Saga

posted in Reviews on December 29, 2017 by Kevin Lehrbass 0 Comments

On Christmas day, when no one was looking, I peeked at twitter and saw a tweet about an Excel based game called The Worksheet Saga. My first thought was “oh…it’s based on VBA. I wonder if the code is unlocked?”.  Read more to see how this game works and how I hacked it to win 🙂 Continue reading →

Compare Text Fonts in Excel using VBA

posted in Gurus on November 16, 2017 by Kevin Lehrbass 3 Comments

Have you ever had the experience where one event causes you to remember something from years ago? This happened to me today while reading the New Yorker magazine. What does Lucas de Groot, a Dutch typeface designer, have to do with Excel’s VBA language? What is “Fontgate”? Well…read on and I’ll tell you! Continue reading →

Formulas or VBA to create military code?

posted in Formula or VBA on February 24, 2016 by Kevin Lehrbass 2 Comments

How do you know whether you should use Excel Formulas or Excel VBA? Sometimes both work and sometimes only one works. This series will explore this question. Let’s start with an idea from Sumit Bansal at TrumpExcel. Continue reading →

Newer posts →

Sometimes I write a practical 'how to' post and other times I explore a crazy idea and build something unique. I love working with data in Microsoft Excel!

Kevin Lehrbass

Newsletter