Add color to letters inside a cell April 26th ,2020 Kevin Lehrbass vba 0 0 Share Facebook Google+ Twitter Pinterest LinkedIn 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. (more…)
Worksheet_Change Keep All Time Min Max Numbers March 22nd ,2020 Kevin Lehrbass vba vba, worksheet change 1 0 Share Facebook Google+ Twitter Pinterest LinkedIn 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. (more…)
use vba to name checkboxes January 18th ,2020 Kevin Lehrbass vba checkbox 1 0 Share Facebook Google+ Twitter Pinterest LinkedIn Over the holidays I saw some vba code for checkboxes from the book ‘More Excel Outside the Box’ by Bob Umlas. (more…)