I’m a beginner when it comes to VBA. I know how to record macros and then go into the editor window and adjust things slightly and that’s about the limit of my ability.
I’ve tried a course on Udemy by the guy who taught me all I know about Excel however it essentially only scratched the surface and didn’t really get into the nitty gritty of writing VBA.
What are some good resources or online courses that you guys would recommend (ideally that also have practical examples included) to really give an in depth understanding of how to read and write VBA?
I’m also aware there are resources in this sub. Are there any in particular you might recommend?
5 Likes
Check this community resources for a list of very helpful tips, topics and tools.
On YouTube one of the best and most extensive VBA channels is “WiseOwlTutorials" check it out.
I did it the old fashioned way. Self-taught to a level, then I bought John Walkenbach’s excellent book ‘Power Programming With VBA’. 2005 for me, but I think J-Walk And Associates is still around on the web these days. He’s the best.
learn.microsoft is the official documentation for VBA
I Google “learn.microsoft VBA [excel] [workbook] [saveas]” whenever I forget the Workbook.SaveAs syntax.
Try changing the square brackets to what you’re looking for and see if that helps getting to information faster.
learn.microsoft VBA documentations 90% of the time include examples. And if you browse though categories you’ll see that they have tutorials and articles on the fundamentals.
Hope that helps!
Am sorry to say this but,Just to be absolutely precise. VBA is soooo old that literally there’s no reason to pay for resources. Youtube, forums and stack are full of necessary info. Also there’s higher probability that a youtube person will share a business use case than an udemy teacher.
The best way is to scroll through YouTube and find a person who’s voice is nice to hear during next 10+ learning hours and go with it. 
or maybe that’s just me.
For my sins, amongst other things, I was a professional VB programmer, so VBA is, to me, really familiar. I’m not boasting with that statement, it’s to provide context.
VBA is a tool. It’s a programming language, pretty dated and kept in play for a few reasons
- Legacy - so many apps written, businesses run on its availability, Microsoft can’t switch it off.
- Flexibility. I most recently used it to create a bit of business critical functionality that was meant to be a sticking plaster, it’s replacement is in the backlog, but it’s tailored solution, combined with the raw end-user-computing capability of Excel itself is proving hard to develop an alternative.
I advise my team to avoid bothering with VBA, there are usually 100 or more better ways to crack that nut.
If you want/need to go there. Remember VB is an old school programming language. Find a way to get VB6 on your computer. Write a game, forget VBA for a while, make VB do cool and interesting things. Learn VB, see how it ticks, for all it’s crap, the fast dev lifecycle and immediateness of BASIC is not really appreciated in the wider, more snobby, if you will, development community.
So that’s my tip. VBA is an in-context version of VB. learn VB, everything is transferable, just another API