VBA sub procedures can perform lots of tasks and there are many ways to execute those functions in Microsoft Excel.

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

This tutorial will explain how to find a value in an Excel column using the Find function in VBA.

Capable of far more than just data organization and spreadsheet-related functionality, Excel can help you crunch large datasets and even automate your most commonly executed tasks in your workflow.

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

Create a UserForm containing a dynamic number of controls and make sure they are being triggered by certain events. To achieve this result, we will use a UserForm and a class module, and assign any ...

How to Program a "Save As" Button in Excel VBA. Offices and small businesses all over the world create countless numbers of Excel spreadsheets every day. Many small businesses create the ...

Is the VBA in Excel 2011 compatible with the version in Office 2004? Yes. Is the Solver integrated into Excel now that VBA is back? (In Excel 2008, it was a separate application and very slow.) Yes.

The default active cell format in Microsoft Excel isn't all that easy to see, but you can use this easy-to-implement code solution to change that.

Encountering error 400 while running a macro in Excel? This guide will help you with multiple solutions to fix VBA error 400 in Excel.