Microsoft Excel 2010 comes with the latest version of Visual Basic for Applications, or VBA, which is a programming language designed to interface easily with Microsoft Office products. VBA allows you ...

In this guide, I will start with VBA basics and give you practical examples of utilizing custom functions to unlock a whole new level of Excel mastery.

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 ...