Best VBA Learning?

SteveOranjinSteve

Board Regular
Joined
Nov 18, 2019
Messages
78
Office Version
365, 2019
Platform
Windows
Hi there,

I've been learning VBA, but I find the VBA tutorials kinda weak. Any thoughts on what is out there? In terms of books/ online classes that I can take? What is the best route to learning VBA as quickly as possible.

Hope you're well,

Steve
 

Some videos you may like

Excel Facts

Last used cell?
Press Ctrl+End to move to what Excel thinks is the last used cell.

Rijnsent

Well-known Member
Joined
Oct 17, 2005
Messages
1,277
Office Version
365
Platform
Windows
What helped me personally (a decade ago): read a chapter of Excel 2007 VBA Programmer's Reference before bedtime every day.
Depending on your learning style you could go for a book (yeah, good old paper), an online course and/or video tutorials. My personal favorites are the courses and the book, tutorials are too slow for me. The ones I like: Excel VBA Programming - a free course for complete beginners and Free VBA Training Course , or if you want something more full-fledged (but generally slower), you could try a course on e.g. Coursera or EDX.
Just scrolled through a list of Excel/VBA books, if I had to buy a book right now, I'd go for "Excel 2016 Power Programming with VBA (Mr. Spreadsheet's Bookshelf)".
 

snjpverma

Well-known Member
Joined
Oct 2, 2008
Messages
1,383
Office Version
2016
Platform
Windows
I am myself a VBA beginner and I have surfed through a lot of videos to get help.
None of them matched the Youtube link given below. Almost all the topics are covered and each one has been explained in depth. I am happy to have come across it.
God Bless Andrew for this!

Click this below given YouTube Link:
VBA Playlist


And good luck to you in your learning journey.
 

Fazza

MrExcel MVP
Joined
May 17, 2006
Messages
9,368
Given you've already been learning VBA, I think the best way is to write more VBA: anything you can do for your work/home, and answer (not just read) questions on this forum. Practice, practice & then more practice.
 

snjpverma

Well-known Member
Joined
Oct 2, 2008
Messages
1,383
Office Version
2016
Platform
Windows
Given you've already been learning VBA, I think the best way is to write more VBA: anything you can do for your work/home, and answer (not just read) questions on this forum. Practice, practice & then more practice.
Absolutely true. I am a beginner in VBA and after watching the video or reading an article it feels as it you know it.
But, when I actually go and start coding I get stuck at number of places. And by actually coding, I am gradually getting the hang of it.
 

Michael M

Well-known Member
Joined
Oct 27, 2005
Messages
18,961
Office Version
2013
Platform
Windows
The advice from @Fazza is very true....and when you finally think you have it nailed, someone will come along it show a faster, cleaner, more efficient method....We are constantly learning !!!
 

montecarlo2012

Well-known Member
Joined
Jan 26, 2011
Messages
528
Office Version
2010
Platform
Windows
wow, interesting, about learning, the question is who really want to teach you, to share maybe paths that do not exist on youtube or whatever site, what about, some person here decide to show something.
I have been trying and trying, and still loop are a pain you know where.
 

Michael M

Well-known Member
Joined
Oct 27, 2005
Messages
18,961
Office Version
2013
Platform
Windows
I did 2 training courses as part of an employment training initiative.....I'm no expert, but I was showing the trainer better methods than were in the training.
Nobody will teach you for nothing....but the free resources here will provide all the info required...here for example....Hiker95's list
While it's great to have access to forums like this, some application from the end user (you) is required. When a solution is provided to a question.....I'd suggest trying to deconstruct that code to see what does / doesn't work. Go ahead and post a question about your looping, see what responses you get. If your lucky you may get numerous responses that you can then compare and try to adjust.
Also, unless you have a project to apply your code to, you will probably never truly get the grasp of VBA.....I recall when I was in school, I had a course called Logic, where they tried to teach me things like, "a=a+1"......how can that work, and I never understood it !!
Many years later, I was doing some very basic coding and needed "a" to keep incrementing by 1....and then it struck me......"a=a+1".....
 

Watch MrExcel Video

Forum statistics

Threads
1,102,186
Messages
5,485,250
Members
407,490
Latest member
leogaleleo84

This Week's Hot Topics

  • Finding issue in If elseif else with For each Loop
    Finding issue in If elseif else with For each Loop I have tried this below code but i'm getting in Y column filled with W005. Colud you please...
  • MsgBox Error
    Hi Guys, I have the below error show up when i try and run my macro in File1 but works fine if i copy and paste the same code into file2. [ATTACH...
  • CELL FORMAT - IF CONDITION
    My Cell Format is [B]""0.00" Cr". [/B]But in the cell, it is showing 123.00 for editing. (123 is entry figure). (Data imported from other...
  • Show numbers nearly the same
    Is this possible. I have a number that can change very time eg 0.00001234 Then I have a lot of numbers 0.0000001, 0.0000002, 0.00000004...
  • Please i need your help to create formula
    I need a formula in cell B8 to do this >>if b1=1 then multiply ( cell b8) by 10% ,if b1=2 multiply by 20%,if=3 multiply by 30%. Thank you in...
  • Got error while adding column and filter
    Got error while adding column and filter In column Z has some like "Success" and "Error". I want to add column in AA if the Z cell value is...
Top