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

Top comments (3)

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!

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!