Home - danielep71/VBA-PERFORMANCE GitHub Wiki

Next

---

Welcome to the VBA-PERFORMANCE wiki!

---

In VBA, writing functional code is straightforward. The macro recorder lets you create procedures that automate tasks without writing any code. However, one common criticism of VBA is that it is slower than other programming languages, such as C++. While this is somewhat true, it's important to note that VBA code can often be improved in terms of structure and efficiency.

Although it's easy to produce code that works in VBA, it can be much more challenging to create code that performs well. Optimized code can be over 1,000 times faster than poorly written code (please click here to see some very clear examples).

In this repository, I will introduce a class module and a selection of tips for measuring and improving VBA performance.

---

Next