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

Hello,I've been trying to learn to write Visual Basic for Excel. One question that my Power Programming Excel VBA book doesn't explain well is:In the VB Editor for Excel in the Project Explorer ...

After creating UserForm1 for one Excel application, you realize that you'll want to use it again -- with a few modifications -- in another application. You do not need to recreate the form; simply ...

The Recordset object is an essential component in Access development, but it often trips up even experienced developers. Susan Harkins explains 12 common Recordset pitfalls you can anticipate and ...

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

This tutorial will explain how to find a value in an Excel column using the Find function in VBA. Excel will highlight all of the cells that correspond to your search. How to search data using the ...