Bump!
No one really addressed vba specifically in this thread.
What language is vba from- Like which language should I learn well if I want to really know how to write vba for excel?
I'm not interested in becoming a whole programmer, but I do use excel and basic macros a lot. - How can I really learn this besides using Google ?
Here you go...
For an intro to VBA there is a course taught at Cal Poly Pomona and available here
https://www.youtube.com/playlist?list=PLZOZfX_TaWAGg2uE_E7fz5SCrHhMaKw8jIt's short clips that are easy to follow, but from what I watched are little theoretical, so if your a hands on learner, you might get a little board. But it's definitely the place to start.
If you want to jump right in, watch the VBAisFun channel on YouTube, he has a beginners playlist, and each video is a hands on example of of something he's trying to accomplish with VBA.
Only downside is that once you actually start coding , you'll realize that 90% of your time will be spent debugging (at least in the beginning), and the more of the [boring] fundamentals you know (for eg. data types) the easier it will be to debug.
For an amazing and comprehensive course on getting started with VBA (and beyond) watch the Excel VBA introduction playlist from WiseOwl tutorials
https://www.youtube.com/watch?v=KHO5NIcZAc4&list=PLNIs-AWhQzckr8Dgmgb3akx_gFMnpxTN5He's very clear and thorough giving you the fundamentals and hands on examples. Downside is that each section is 40+ minutes.
If you're just starting out with programming, I would watch the first few lectures of CS50 just to get some background in computer science (bits, memory etc.)