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.

You can use the same method to create many print functions in Excel using VBA. Steps for creating the print function button are the same; just the command syntax differs.

This VBA macro generates a list of Microsoft Word styles that are custom, built-in or both.

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.

Both Select Case and Like operators are powerful and extremely useful commands in VBA language , but under normal circumstances, they don't work together. In this article you will learn how to ...