DEV Community

loading...

Discussion on: VBA Resources

Collapse
rubberduck profile image
Christopher McClellan

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!