VBA Debugging Tips
Debugging your procedures can be a frustrating job, even during the best of times. Here are a few tips to keep in mind when tracking down programming problems. Following these sections: Read more...
MS-Excel - General Formatting Tutorials
VBA Functions
VBA boasts more than 160 built-in functions that cover data conversion, dates and times, math, strings, and much more. Read more...
VBA Tips
In this tutorial (with the possible exception of the section "Tips for Faster Procedures"), they're indispensable when you do need them. Read more...
Creating Custom VBA Dialog Boxes
This tutorial starts you off by showing you how to use VBA's Microsoft Forms feature to create custom dialog boxes and input forms. Read more...
Excel Programming
This tutorial looks closely at that interaction. You learn how to work with all the most common Excel objects, including the Workbook, Worksheet, and Range objects. Read more...
Controlling Your VBA Code
One of the advantages of writing your own VBA procedures instead of simply recording them is that you end up with much more control over what your code does and how it performs its tasks. Read more...
Working with Objects
Many of your VBA procedures will perform calculations using simple combinations of numbers, operators, and the host application's built-in functions. Read more...
Building VBA Expressions
This tutorial takes you through some expression basics and shows you a number of techniques for building powerful expressions using not only variables, but also VBA's built-in functions. Read more...
Understanding Program Variables
This tutorial explains this important topic and shows you how to use variables in your VBA procedures. Read more...
Writing Your Own Macros
This tutorial introduces you to the basics of writing simple procedures and functions, as well as how to get around in the Visual Basic Editor, which is the tool that VBA provides for writing macros by hand. Read more...