DEV Community

Ryan
Ryan

Posted on

VBA Resources

Hi everyone,

I am looking to get into learning VBA specifically for Access and Excel. Does anyone have solid sources that they could recommend whether it be videos or work-alongs?

Thank you in advance,
Ryan

Latest comments (3)

Collapse
 
notepadclip profile image
notepad-clip • Edited

Notepad here you will find articles that will help you solve problems in your notepad
notepadwin.com
thank you hopefully can help you!

Collapse
 
vitosh profile image
Vitosh Academy

The MSDN is actually quite a good reference:
msdn.microsoft.com/en-us/vba/vba-l...

Riptutorial.com is the ex-documentation of StackOverflow. It was good, but they have removed it. Still, for VBA the articles are quite nice:
Riptutorial.com

Although it looks rather old, this is quite a nice site, where plenty of #VBA people leaned from:
rondebruin.nl

This is my own blog, I usually blog once per week for C#, VBA and books. The articles are not related to each other, their main idea is to help me (or whoever is looking at them) to solve a specific problem:
vitoshacademy.com

Collapse
 
rubberduck profile image
Christopher McClellan • Edited

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!