Home - danielep71/VBA-PERFORMANCE GitHub Wiki

Next

---

Welcome to the VBA-PERFORMANCE wiki!

---

In VBA, it's easy to write code that works. Using the macro recorder, it is even possible to create procedures that automate some tasks without writing a single line of code.

Unfortunately, one of the criticisms against VBA is that it is slow compared to other languages, such as C++. While there is some truth in that, it must be said that VBA code could be better written and/or better structured.

Indeed, while it's easy to write code that works in VBA, it's harder to write code that works fast. Optimized code can be even more than 1000 times faster than poorly written code (please click here to see some very clear examples).

In this repository, I will introduce one class module and a selection of tips to improve VBA performance.

---

Next