top of page
Search


Sum Excel by Color - Which is the Easy Way?
Summing Excel cells by color: an "easy" way and a "hard" way.

Kimberlee Martin
Mar 12, 20243 min read
Â
Â
Â


VBA Dates
Excel and MS Access store dates as numeric fields, allowing for each calculations in VBA.

Kimberlee Martin
Jan 11, 20234 min read
Â
Â
Â


VBA: Three Ways to Handle Text in Numeric Fields
Users will make mistakes, and some of those will impact your VBA code. Here are three ways you can handle that.

Kimberlee Martin
Jan 3, 20235 min read
Â
Â
Â


Doubles, but No Troubles
Use VBA to check for nearly identical data in your Excel worksheet.

Kimberlee Martin
Dec 19, 20224 min read
Â
Â
Â


Auto-replace Text in Excel Cell with VBA
In recent posts, I’ve been talking about validating your Excel data using VBA. I talked about creating a validation harness, which you...

Kimberlee Martin
Dec 6, 20222 min read
Â
Â
Â


Parse Phone and Extension with VBA
Last week, I wrote a blog post about creating a validation harness in Excel VBA. I laid out a structure you can add to your Excel file...

Kimberlee Martin
Nov 28, 20226 min read
Â
Â
Â


Validation Harness in Excel VBA
Adding a Visual Basic structure to your Excel file for validating data.

Kimberlee Martin
Nov 18, 20229 min read
Â
Â
Â


Debugging VBA without Line Numbers
I wrote a post several years ago about adding line numbers to your VBA code. To this day, it remains my post popular post ever. Why? It’s...

Kimberlee Martin
Nov 7, 20223 min read
Â
Â
Â


Option Explicit
If you’ve ever written VBA code in Excel, Access, or any of the other products in the Microsoft Office suite, you may already be familiar...

Kimberlee Martin
Apr 17, 20173 min read
Â
Â
Â


VBA Line Numbers
How to add line numbers to VBA

Kimberlee Martin
Mar 29, 20173 min read
Â
Â
Â


Creating a Timer in Excel
The other day I had a client ask me to create a reminder in an Excel document that would pop up several times a day. It had to run at...

Kimberlee Martin
Feb 16, 20176 min read
Â
Â
Â


Recording Flexible Macros
Recording macros in Excel is an easy way to automate repetitive tasks. Maybe you receive a new file every month with your sales figures...

Kimberlee Martin
Jan 2, 20175 min read
Â
Â
Â


What is Excel VBA?
If you've ever thought about creating macros in Excel, you've probably heard the term "VBA". In this post, I'm going to give you a little...

Kimberlee Martin
Oct 31, 20164 min read
Â
Â
Â
CATEGORY
ARCHIVE
bottom of page