top of page
Search


VB Script vs. VBA
VB Script and VBA are two different things - do you know which is which? What will happen now that VB Script is deprecated?

Kimberlee Martin
Nov 2, 20233 min read
Â
Â
Â


Three Reasons to use Named Ranges in Excel
Here are 3 good reasons to use named ranges in Excel.

Kimberlee Martin
Oct 17, 20234 min read
Â
Â
Â


Excel Stopwatch
Create a stopwatch on your Excel worksheet to track hours, minutes or seconds for your task.

Kimberlee Martin
Sep 28, 20236 min read
Â
Â
Â


Detecting #N/A with VBA
Using VBA code to check for #N/A in an Excel cell. The CVErr function allows you to check for several of the "#" errors in Excel.

Kimberlee Martin
Sep 19, 20233 min read
Â
Â
Â


BEEP! An Audible Alarm in Excel
Create an audible alarm in Excel that beeps when a timer expires.

Kimberlee Martin
Sep 14, 20233 min read
Â
Â
Â


Scheduling Excel Macros with a Timer
A while back, I wrote about creating a timer in Excel. In that post, I went into detail about my failed attempts to create one, and how I...

Kimberlee Martin
Aug 8, 20234 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
Â
Â
Â
CATEGORY
ARCHIVE
bottom of page