VBA recomendations

  • Thread starter Thread starter Mark
  • Start date Start date
M

Mark

I'd like to learn VBA from the scratch so I could write some of my own
codes instead of bothering you guys every time I need something new
Don't misunderstand me, I really appreciate you help but I'd like to
understand what you giving me and I'm ashamed to ask every time you
give me a code how to read it so I could modify it if I need to
So, do you have any suggestions where to start? maybe some web sites?
books? whatever...
Again, appreciate your help

Mark
 
I did a lot of research looking for a good book to learn VBA because
I'm right there with you. Unfortunately, I didn't find anything similar
to a book I bought years ago when I was learning it then (didn't get
too far, the client changed their mind and the classes I was going to
do for them didn't happen). It was something like "Learn XL VBA in 21
days". The title was very optimistic, but was an excellent book. I
liked it because it gave a lesson, then an exercise, then a lesson,
etc.
I did buy Walkenbach's book, XL2000, Power Programming with VBA, and I
think it's good, but not a great starter book like the previous one. It
just describes features and has a lot of demo code, and would be far
more useful, like so many manuals, if it were really thoroughly
indexed.
I looked at the "Dummies" book, and it looks the same as the others
only less technically written. I didn't opt for it because I have a lot
of technical training (engineering school) and some experience with
VBA. But it looked like it would be good if you didn't have a technical
or VBA background.
If you find something better than what has been suggested here, I'd
love to hear about it. Best of luck!
 
Debra Dalgleish has a list of books at:
http://www.contextures.com/xlbooks.html

I think I'd look at John Green's (and others):
Excel 2002 VBA Programmers Reference

and that group of authors just released a new book.
Professional Excel Development by Stephen Bullen, Rob Bovey, John Green

But if you had problems with John Walkenbach's book, I think I'd print that list
from Debra's site and visit my local book store/library to find the one that fit
best.
 
Back
Top