VBA has completely transformed the way I interact with Excel. It does require a learning curve, though, and at times you may even encounter errors while executing your custom functions.

If you want to accomplish the same thing from inside Excel—for instance, display and populate an appointment while working in Excel—you’ll need a bit of VBA magic.