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?
top of page
Search
Kimberlee Martin
- Oct 17, 2023
- 4 min
Three Reasons to use Named Ranges in Excel
Here are 3 good reasons to use named ranges in Excel.
18 views0 comments
Kimberlee Martin
- Sep 28, 2023
- 6 min
Excel Stopwatch
Create a stopwatch on your Excel worksheet to track hours, minutes or seconds for your task.
28 views0 comments
Kimberlee Martin
- Sep 19, 2023
- 3 min
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.
27 views0 comments
Kimberlee Martin
- Sep 14, 2023
- 3 min
BEEP! An Audible Alarm in Excel
Create an audible alarm in Excel that beeps when a timer expires.
13 views0 comments
Kimberlee Martin
- Aug 8, 2023
- 4 min
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...
24 views0 comments
Kimberlee Martin
- Jan 11, 2023
- 4 min
VBA Dates
Excel and MS Access store dates as numeric fields, allowing for each calculations in VBA.
15 views0 comments
Kimberlee Martin
- Jan 3, 2023
- 5 min
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.
10 views0 comments
Kimberlee Martin
- Dec 19, 2022
- 4 min
Doubles, but No Troubles
Use VBA to check for nearly identical data in your Excel worksheet.
20 views0 comments
Kimberlee Martin
- Dec 6, 2022
- 2 min
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...
25 views0 comments
Kimberlee Martin
- Nov 28, 2022
- 6 min
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...
19 views0 comments
Kimberlee Martin
- Nov 18, 2022
- 9 min
Validation Harness in Excel VBA
Adding a Visual Basic structure to your Excel file for validating data.
14 views0 comments
CATEGORY
ARCHIVE
bottom of page