How do you learn other things? If you like to learn on your own, using a
book, then that's a good way to learn VBA. There's a book list he

http://www.contextures.com/xlbooks.html

Go to a local bookstore or library, and flip through the Excel VBA
books, to see which writing style you like best.

If you prefer to learn in a class, where you can see examples, and ask
questions, then follow Martin's suggestions for finding a class.

There are also on-line tutorials. David McRitchie has a list:

http://www.mvps.org/dmcritchie/excel...m#vbatutorials



Essonc wrote:
Hi, Can anyone advise the best way to learn VBA?

Is it via books? and if so what's a good one to start with?, Do I get
one on one tuition?

I am a beginner in VBA, however have used excel fo 10 years or so. I am
fairly conversant with formula, in that I use certain functions
regularly, e.g sumproduct, vlookup, pivot tables, I can build simple
macros, concatenate, replace, mid, left, right, substitute. I realise
that I am only using a very, very small percant of excel capabilities,
but in order to develop some ideas would love to know how the coding
works, the basic blocks to start with.

Any help greatly received.

Thanks





--
Debra Dalgleish
Contextures
http://www.contextures.com/tiptech.html