https://lichess.org/ has a Zen mode. Can I create a Zen mode in Excel to celebrate Spreadsheet Day?
Post Category → vba
Add color to letters inside a cell
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
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
Over the holidays I saw some vba code for checkboxes from the book ‘More Excel Outside the Box’ by Bob Umlas.
Continue reading