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

Users will make mistakes, and some of those will impact your VBA code. Here are three ways you can handle that.

Use VBA to check for nearly identical data in your Excel worksheet.

In recent posts, I’ve been talking about validating your Excel data using VBA. I talked about creating a validation harness, which you can leverage to validate any Excel data. Then I covered some phone number validations you might add to that harness. Today I’m going to talk about using that harness to automatically replace text that a user may enter. I consider this part of data validation, because you can use it to head off data issues. Here’s an example: Converting "K" to

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 that allows you to add custom validation as users are entering data. Now that we’ve laid that framework, we can work on adding some useful validation. Phone Numbers and Extensions Today, we’re going to look at phone numbers and extensions. When setting up an Excel file, it’s common for people to create a single column that is used for both, as

Adding a Visual Basic structure to your Excel file for validating data.