I agree with Tom. The book by the big four is great if you already have
some experience and need some specific help. John's book is different,
because you can read it at several different levels, and it includes
guidance on how to think about setting things up, without diving
headfirst into the code. I use them both, as well as the Getz and
Gilbert VBA Programmers Handbook. Plus the help files.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
http://PeltierTech.com/Excel/Charts/
_______

Tom Ogilvy wrote:

Everyone has their own opinion. I will share mine. I believe the book
recommended by Bob is more appropriate if you have experience programming
already and just need to focus on Excel. For someone with little or no
programming experience, I would recommend John Walkenbach's book. I would
actually recommend getting both, but starting with Walkenbach's. For an
easier start (more tutorial), you might check out books by Reed Jacobson
(Excel version VBA Programming Step by Step) published by Microsoft press.
For Excel 2000, I believe they changed the title, but I think it is back to
Step by Step now.

Here is a sample chapter from an older version (still applicable to versions
of Excel after xl97)

http://www.microsoft.com/ExcelDev/Articles/sxs11pt1.htm
Lesson 11: Creating a Custom Form
Excerpted from Microsoft® Excel 97 Visual Basic® Step by Step.


--
Regards,
Tom Ogilvy

Bob Phillips wrote in message
...

"Excel 2002 VBA Programmers Reference", by John Green, Rob Bovey, Rom
Rosenfield, Stephen Bullen et al, is my personal recommendation, but you
might want to check out the books Debra Dalgleish lists at
http://www.contextures.on.ca/tiptech.html

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

"scott23" wrote in message
.com...

Can someone offer some advice as to the best book for a
begginer/intermediate looking to get away from recording macros'...
and start writing them ?
Thanks
scott