Hi
start with a project close to you that you really feel should be
automated.
Get the two books "Excel VBA for Dummies" by John Walfenbach and "Excel
2002 VBA" by Stephen Bullen, John Green, Rob Bovey and Robert
Rosenberg.
Look at this newsgroup everyday. Search this newsgroup for particular
problems you come across or clarifications you might require. You will
be extremely unlucky not to find what you want. Ask short detailed
questions here and look for answers within the hour or they will scroll
off the screen.

regards
Paul

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



--
Essonc
------------------------------------------------------------------------
Essonc's Profile: http://www.excelforum.com/member.php...o&userid=14652
View this thread: http://www.excelforum.com/showthread...hreadid=535437