How long does it take to become comfortable with VBA?

Answer 1

It is highly dependant on your own ability to pick up and learn the syntax for the language (It is very similar to VB.net in terms of the actual wording and syntax).

Alongside that, if you have any experience in programming logic this time will be reduced significantly, since most languages have some fundamental similarities (Looping for example).

Start with excel and record a few macros and do some simple things on screen, flick to the visual basic for application editor and check out what you did in code and come to understand the object and properties relationship. (E.g ActiveCell.Value = 1)

Start to look at a few sources to explain the concept of iteration to you (E.g. instead making Cells A1:A10 yellow by writing 10 different lines of code, loop through the cells and make each one yellow as you go along).

Finally, start looking into object oriented programming and learn to separate your code into smaller functions and subroutines so they can be used with greater extensibility.

(E.g. if you have 300 different subroutines that all make something yellow, and you decide you want it to make it red instead, you have to change 300 lines of code, instead if you make them all point to the same location, you only have to change 1)