VBA is a powerful program that enables non-programmers to create and edit macros. Learn how to enable & use VBA in Microsoft Excel.

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.

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.

Tips When creating .NET class libraries, name them anything you like. To reference them in VBA, use the name of the .NET class library as shown in the previous example.

A Microsoft programming language VBA (Visual Basic for Applications) is extremely useful to create custom tables and reports, perform calculations and create functions in Excel. However, in order to ...

This month’s column shows how to use the remarkably versatile AGGREGATE function in Excel.

How to use wildcards with the XLOOKUP() function in Excel Your email has been sent Microsoft Excel’s XLOOKUP() is powerful, but combined with wildcards, it’s also flexible. Lookup functions ...