I was just introduced to the concept of unit testing. What this means is writing code to test your code. So why would we want to write more code than what we actually need to?
Well, the answer is simple. This helps to automate our testing and also makes sure that as we write more code and change bits and pieces here and there, we can be ensured that our old code still works as expected.
Now, writing Unit Tests are part art and part science. But it does seem like a good idea that I will try to incorporate for my clients even though I'm mostly dealing with small scripts here and there.
One thing I'm not sure of, is how to write unit test code for VBA. That's something that I need to look into.