Home » Posts Tagged "vba"

When is the right time to learn Visual Basic for Applications?

If you’ve ever tried to tackle a Microsoft Office Visual Basic for Applications (VBA) project yourself, then you know how daunting that can be.  While there are built-in Office tools to help you create macros and perform advanced data analysis, at some point you may realize that the default tools are not good enough.  By learning Visual Basic for Applications on your own, you can extend the functionality of your Office programs.

read more

Advanced Excel Data Analysis – Data Table

While working in Microsoft Excel on data analysis, there are a handful of built-in analysis tools available. If you’re interested in studying the effect that a range of values has on the formula, you should consider setting up a data table.

read more

Custom Excel Visual Basic Application – Project Review – NM Industrial Service

The goal of this project was to create an automated solution to create the cover sheets and submittal registers that had been created manually in Excel in the past. After reviewing the current processes with NMIS, DWC determined that they did not have a current system in place to create these documents. Different users created the forms in different ways, and there was a lack of consistency of the final product.

read more