My Spreadsheet Lab

The site is about Microsoft Excel.

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

Post Category → vba

Zen Mode

posted in vba on October 17, 2021 by Kevin Lehrbass 3 Comments

https://lichess.org/ has a Zen mode. Can I create a Zen mode in Excel to celebrate Spreadsheet Day?

Continue reading →

Add color to letters inside a cell

posted in vba on April 26, 2020 by Kevin Lehrbass 0 Comments

VBA can color certain characters within a cell. It was fun to practice vba and build this but it doesn’t work well with many rows of text. Continue reading →

Worksheet_Change Keep All Time Min Max Numbers

posted in vba on March 22, 2020 by Kevin Lehrbass 1 Comment

Excel is not meant to store historical data. That’s what databases do. However, Tom Urtis shows us a trick to keep the all time min value from a single input cell. Continue reading →

use vba to name checkboxes

posted in vba on January 18, 2020 by Kevin Lehrbass 1 Comment

Over the holidays I saw some vba code for checkboxes from the book ‘More Excel Outside the Box’ by Bob Umlas.
Continue reading →