DEV Community

Discussion on: VBA Resources

Collapse
rubberduck profile image
Christopher McClellan • Edited on

Chip Pearson’s site is one of the best resources on the web for learning VBA. Chip (RIP) taught several generations of us how to code.

cpearson.com/Excel/MainPage.aspx

VBA4All is also a great resource, but you’ll unfortunately need to use the internet archive version.

web.archive.org/web/20140913092220...

I would also check out the Rubberduck VBA blog. Rubberduck is an add-in for the VBA Editor, but the maintainer, Mat, often writes about how to write clean and maintainable VBA.

rubberduckvba.wordpress.com/

Lastly, I’d recommend reading my older blog posts, back from when I was still working with VBA and helping Mat build Rubberduck.

christopherjmcclellan.wordpress.com/

I don’t work with VBA anymore, so I haven’t written about it in a while, but learning it (and subsequently C# for Rubberduck) is what launched my career in software. Good luck!