VBA Overflow Error
The Overflow error occurs in Visual Basic when you exceed the limits of a variable's data type.
top of page
Search
Kimberlee Martin
- Jan 27
- 3 min
VBA: Data Type Conversion
VBA's automatic type conversion feature sometimes causes it to concatenate instead of add.
3 views0 comments
Kimberlee Martin
- Jan 11
- 4 min
VBA Dates
Excel and MS Access store dates as numeric fields, allowing for each calculations in VBA.
3 views0 comments
Kimberlee Martin
- Jan 3
- 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.
3 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.
7 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...
7 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...
9 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.
7 views0 comments
Kimberlee Martin
- Nov 7, 2022
- 3 min
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...
4 views0 comments
Kimberlee Martin
- Jun 7, 2022
- 3 min
Dynamic Highlighting in Excel
Find cells containing specific text A customer called me today to ask a question about Excel. I thought it was an interesting challenge,...
23 views0 comments
Kimberlee Martin
- Jan 18, 2021
- 5 min
Temporary Watermark in Excel
Adding a Watermark to an Excel document only when printing
28 views0 comments
Kimberlee Martin
- Apr 18, 2017
- 3 min
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...
19 views0 comments
Kimberlee Martin
- Feb 16, 2017
- 6 min
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...
167 views0 comments
Kimberlee Martin
- Jan 3, 2017
- 5 min
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...
33 views0 comments
Kimberlee Martin
- Oct 31, 2016
- 4 min
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...
28 views0 comments
CATEGORY
ARCHIVE
bottom of page