Archive for VBA

You are browsing the archives of VBA.

Poll: Do you use VBA in your Excel files?

I just added a poll to the sidebar on the right (RSS readers might need to visit the site to see it). I’d like to know if you use recorded macros or write VBA in Excel.
I ran an informal poll among friends and colleagues with catastrophic results and I’d like to compare results.
Please add a […]

Excel Dashboards: do you need VBA?

Do you need VBA to create an Excel dashboard? Should you take the plunge and go beyond Excel formulas? Well, I think you should, but feel free to disagree. Charley Kyd, commenting on my review of his e-book, disagrees:
As a consultant, I visited too many clients where an Excel user had written some macros, used […]