These built-in functions fall short when you want to automate specific tasks or perform unique calculations in your databases. Here is where the magic of VBA (Virtual Basic for Applications) comes in.

You can create custom Excel functions using VBA matching using your criteria. Create custom Excel functions using Macros in Excel & use user-defined functions in Excel.

Build a custom Excel function library in minutes! Learn how to use VBA, create a personal macro workbook, and design a custom ribbon tab.

When a VBA solution falls short of your needs, there's probably a Windows API function that can handle the job. Susan Harkins lists 10 handy APIs and explains how you can put them to work.

How to Use .NET Class Library in Excel VBA. Your business's software developers can work with Microsoft's .NET framework to create powerful Excel macros for your spreadsheets. The .NET framework ...