VBA triggers this event procedure every time you make a change in the sheet. That makes it a bit risky to use in a very busy worksheet—it can slow things down a bit.

I've got an Excel 97 worksheet in which I need to validate some cells. No problem, I'll just use Data->Validate, right? Wrong. The built in validation works well enough as long as the user doesn't ...

Microsoft Excel is a powerful tool that can be used for data manipulation. To make the most of the software, you need to use VBA. Visual Basic for Applications, or VBA, allows Excel users to create ...

This tutorial will explain how to find a value in an Excel column using the Find function in VBA. Excel will highlight all of the cells that correspond to your search. How to search data using the ...

You could do the same with any date component. For instance, you could reject all dates that aren’t in the month of January by using the MONTH () function. Let’s complicate things a bit.