VBA Training

[Jriley_11]

Does anyone have any info or advice on learning VBA? I am a novice when it comes to coding and would like to beginning learning how to code.

 

[Joe4]

There are some good options at the MrExcel store.
Take a look at the third featured item here: The MrExcel Store - Welcome to The MrExcel Store
(it scrolls through them automatically, but you can click on the third one manually too).

 

[montecarlo2012]

Does anyone have any info or advice on learning VBA? I am a novice when it comes to coding and would like to beginning learning how to code.

Hi. very interesting question, I am in the same spot.
First things first. what do you expect from the teacher, or book or video.
in other words what learning and teaching really mean.
what I have been trying, until now really do not work, mean youtube, books, etc. all are the same about VBA precooked code

What I realize talking with people, is, most of the "super-starts" that make code like magic, they know another languages, they study a bundle of ideas, but not just VBA
let me tell you:
Just in a couple videos somebody use flowchart and connect this with the vba code
they have, the programmers something they call Desk-check, do you believe in a vba book or video they will tell you this, answer NO.
desk-check helps a lot with the logic behind the code, in other words use pencil and paper before you computer.
programmer also use ►hand-tracing◄ do you believe in a vba book or video they will tell you this, answer NO
this part talk about the loops I got some good ideas from here. like every loop have START, CHECK, DISPLAY, GOBACK
programmer also learn about IPO charts do you believe in a vba book or video they will tell you this, answer NO
IPO stand for I = input, P = process and O = output, meaning, you READ IN ENGLISH your problem or situation and from there separate what is your process info, data that you have to write, and the result you expect or Output, this help with the logic
and there are more that I am still trying to catch up. But remember, Here is to answer your questions no To give you a tutorial.
and the books they take VBA as a language, assuming you know already:
Data structure
Logic
Some math principles
algorithms
pseudocodes
desk checking
hand tracing
finite state machine and so on,
I am trying my friend, all by myself
there are very nice and kind people here that with the code they upload, you can break it apart and try to understand what they do, difficult but, you know
sometime the guys here they take a little extra minute and explain step by step but in my account, happen to me one time, but anyway a really appreciate this forum
there are genius here, to answer your code, but no time for walking with you or me. Busy people, Great People.
thank you.