My Spreadsheet Lab
  • Home
  • Templates
  • Excel Tips
  • Video Tutorials
  • Excel Blog
  • Excel Coach
  • Excel Training
  • Contact Kevin

vba

You are here: HomeArticlesArchive by Category "vba"

vba

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…)

Share

Newsletter

Do You Excel?

Kevin_Col-275x300-small-2019.png
“Improving your Excel skills can change your career!. Visit my 'EXCEL TRAINING' section!”

- Kevin Lehrbass

Excel Made Easy

Learn Excel

Free Templates

Video How-To's

© 2014 My Spreadsheet Lab| Entries (RSS)
website design & development by Engine Communications