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

Use Excel's formatting and data validation features to validate phone numbers

Use MS Access to clean phone numbers in your Excel data.

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

Use Excel tools to validate a U.S. state.

Excel data can be messy. Use MS Access features to clean it up.

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 because they can be a useful tool in your debugging arsenal. Taking a walk down memory lane, old-school computer programmers will remember that line numbers were crucial back in the day. Whenever there was a problem with your program, you were always referred to a particular line number, identifying the command that was failing, which gave

Use an append query to add Excel data to an Access table