PDA

View Full Version : Best book to learn VBA?



jumpmanjones
04-03-2006, 06:00 PM
what is the best book to use to learn VBA, that is easy to understand and goes in depth into all the tools of VBA and has many different examples?

Howard Kaikow
04-19-2006, 09:45 AM
what is the best book to use to learn VBA, that is easy to understand and goes in depth into all the tools of VBA and has many different examples?

There is no "best" book.

Which book to start with depends on which Office app interests you most and what is your programming background.

VBA is actually made up of a subset of VB and, for each app. an application dependent object model.

If you seriously want to learn VBA, learn VB first.

Best VB book is likely Gary Cornell's Visual Basic 6 from the Ground Up.

If Word is the app of interest, see http://www.standards.com/index.html?WordVBABooks. (http://www.standards.com/index.html?WordVBABooks)

A number of the books listed will also help for more general VBA that may be used with Excel and Access, in particular the book by Ken Getz.

For Excel, start with books by John Walkenbach.

For Outlook, start with Sue Mosher's book.

matthewspatrick
04-21-2006, 05:57 AM
There is no "best" book.

Indeed. Individual learning styles differ. Different approaches work for different apps. Different students of VBA come to the table with varying experience in programming.

For some people, like me, books are only a very small part of the VBA learning process. I have a ton of books on VBA development for Excel, Access, and Outlook, and they are valuable references, but I find I learn much more from trying to "just do it", trying to answer questions here and at other fora, and from working with other forum experts to get my own questions answered.

Amro
05-01-2006, 03:33 AM
:dunno no books here:banghead:

Jacob Hilderbrand
05-01-2006, 08:22 AM
We do offer training here (www.vbaexpress.com/training (http://www.vbaexpress.com/training)) but no books. You can check out some books here (http://www.mrexcel.com/sunshop/index.php?action=&id=&subid)

Apollo
06-11-2006, 04:35 PM
VBA for Modelers by S. Christian Albright

This is a good book to help learn VBA.

Zack Barresse
06-15-2006, 04:11 PM
John Walkenbach does have some good books. Also, check out the books by Stephen Bullen, Rob Bovey and Josh Green, excellent as well. Bill Jelen's (aka MrExcel) latest VBA book is good too IMHO, VBA and Macros for Microsoft Excel.

JohnnyBravo
07-06-2006, 08:10 AM
Jumpman,

I've been trying to teach myself some VBA and recently bought "Dummies for VBA". Based on other Dummies series books I've read in the past, I expected this book to be just as engaging and very easy to follow. I've been very disappointed thus far and I am now searching for better book.

Here is one I have found: The Absolute Beginner's Guide to VBA (http://www.mcfedries.com/)

Scroll down towards the bottom of the page.

malik641
07-19-2006, 08:12 PM
There is no "best" book.
Definitely.

Isn't that kind of a hard question in general? Whose going to read 5 beginner books about the same Microsoft App for VBA? I know I wouldn't. I'd go beginner, advanced, then crazy ridiculous.

But also like Howard said, whatever app interests you the most. Then work your way down the list.


I hope that jumpman checks up on this thread...as it's the only post he made so far...

And welcome, btw.

matthewspatrick
07-19-2006, 08:15 PM
I'd go beginner, advanced, then crazy ridiculous.

I go right for crazy ridiculous :whip

malik641
07-19-2006, 08:23 PM
I go right for crazy ridiculous :whip
I tried...but then I felt crazy stupid.

kysu2tung
08-01-2006, 03:29 AM
Hi All,

Programming.Excel.with.VBA.and.dot.NET.Apr.2006
Please check:
http://www1.7622.com/OReilly.Programming.Excel.with.VBA.and.dot.NET.Apr.2006.chm
or
http://www2.7622.com/OReilly.Programming.Excel.with.VBA.and.dot.NET.Apr.2006.chm

AutoCAD.2006.VBA.A.Programmers.Reference.Sep.2005
http://www2.7622.com/Apress.AutoCAD.2006.VBA.A.Programmers.Reference.Sep.2005.pdf
or
http://www1.7622.com/Apress.AutoCAD.2006.VBA.A.Programmers.Reference.Sep.2005.pdf

Good luck
kysu2tung

kysu2tung
08-01-2006, 03:33 AM
Hi All,
Please check the links:
Professional Excel Development : The Definitive Guide to Developing Applications Using Microsoft(R) Excel and VBA(R) (http://www.flazx.com/ebook2781.php)
Excel 2003 VBA Programmer's Reference (Programmer to Programmer) (http://www.flazx.com/ebook5122.php)
Access 2003 Programming by Example with VBA, XML, and ASP (http://www.flazx.com/ebook2860.php)
Microsoft Excel VBA Programming for the Absolute Beginner, Second Edition (For the Absolute Beginner) (http://www.flazx.com/ebook5077.php)
VB & VBA In A Nutshell (http://www.flazx.com/ebook545.php)
VB and VBA in a Nutshell: The Languages (http://www.flazx.com/ebook4979.php)
Access 2003 VBA Programmer's Reference (Programmer to Programmer) (http://www.flazx.com/ebook3140.php)
Microsoft Excel VBA Programming for the Absolute Beginner (For the Absolute Beginner (Series).) (http://www.flazx.com/ebook3319.php)
Microsoft Access VBA Programming for the Absolute Beginner, Second Edition (For the Absolute Beginner) (http://www.flazx.com/ebook3325.php)
Programming Excel with VBA and .NET (http://www.flazx.com/ebook4816.php)
AutoCAD 2006 VBA: A Programmer's Reference (Programmer's Reference) (http://www.flazx.com/ebook4207.php)
Beginning Access 2002 VBA (Programmer to Programmer) (http://www.flazx.com/ebook4319.php)
Access VBA Programming (http://www.flazx.com/ebook5178.php)
Mastering Excel 2003 Programming with VBA (http://www.flazx.com/ebook2328.php)

Good luck
kysu2tung

Ken Puls
08-01-2006, 08:32 AM
Although I, too, will agree with the "no best book" philosophy, my personal favourite is John Walkenback's Excel 200x Power Programming With VBA. I've consumed it cover to cover, and still refer back to it.

:)

fmkjr
08-06-2006, 04:58 PM
I read through at least 4-5 books on VBA... Mr Excel, Mr Spreadsheet and a few others... another that helped was Master Visually excel 2003 vba programming...
If you live near akron, oh. Bill Jelen (mr excel) has a one day workshop that is outstanding... the class made a word of difference for me getting me started in the "right" direction.

Lammutaja
08-07-2006, 07:03 AM
When You can read russian: :think:
then I suggest You books by Andrey Garnaev:
http://www.apmath.spbu.ru/~kmms/garnaev/default.htm

I have A. Garnaev VBA, in the Original, BHV-Saint Petersburg (http://www.bhv.ru/), Saint Petersburg, 2005, 820 pp. (in Russian)
and it is very good book.

CodeMakr
12-06-2006, 11:08 AM
John Walkenbach's Power Programming with VBA is an excellent starting point, as well as good reference material as you go.

Howard Kaikow
12-06-2006, 03:37 PM
John Walkenbach's Power Programming with VBA is an excellent starting point, as well as good reference material as you go.
That book is for Excel.

IgnBan
03-21-2008, 01:18 PM
If we are talking books we are talking two things; learning and referencing a subject, right? books are still the best for referencing, but these days there are new methods of learning like video tutorials, I found myself in the beginning stage of learning and video tutorials a better way to learn faster than a book (at the beginning learning stage) after that you keep you books to keep learning. I got some for .Net Excel, Access, etc, and before taking a class I get the video tutorial, take the class (including the class book that some times is hard to assimilate a 500 page book in a 16 class semester) and then read the books for ever. These video tutorials are very affordable from 20 to 100 dollars, and no I'm, not talking about Video Professor, those are very old way to learn, the new ones are more like recording a class, or somebody reading you the book and giving you samples in the IDE. Also let's not forget online video tutorials like http://www.learnvisualstudio.net/ and other good sites. Again this is when you start learning a programming language (with this I mean the majority of the Forum members)

PSL
02-23-2009, 10:24 AM
Hi,

Im looking for a book to learn VBA aswell, However being a Commerce grad through and through have absolutely no prior experience with coding.

I am able to record macro and do minor editing. But writing one from scratch.
Only need macros for excel though..

Any books that someone can suggest me?

Thanks in advance

Howard Kaikow
02-23-2009, 04:44 PM
Hi,

Im looking for a book to learn VBA aswell, However being a Commerce grad through and through have absolutely no prior experience with coding.

I am able to record macro and do minor editing. But writing one from scratch.
Only need macros for excel though..

Any books that someone can suggest me?

Thanks in advance
A place to start is http://spreadsheetpage.com/
Check out John WAlkenbach's book, listed at that web site.

Start with the Power Programming and Formulas books.

Also, http://www.bmsltd.co.uk/ProExcelDev/Default.htm

A quick start, if still published, would be the MSFT Press' Excel VBA Step by Step.

khanjee
02-26-2009, 12:43 AM
Fellows,
Is there available a CD of Training, like, lynda.com for learning VBA ?
Comments please.

MaximS
03-14-2009, 01:57 AM
The best books I've ever found is www.google.com (http://www.google.com) and www.vbaexpress.com/forum (http://www.vbaexpress.com/forum). First to find the reference to each function/method, second for finding ideas, solutions and testing your skills.

Zack Barresse
03-15-2009, 10:31 AM
Fellows,
Is there available a CD of Training, like, lynda.com for learning VBA ?
Comments please.
MrExcel.com has some good resources as well for VBA examples. The CD with examples on it is very nice. I think there is a cost associated with it though.

khanjee
03-15-2009, 08:52 PM
Many thanks. :)

sujeet
03-22-2009, 02:59 AM
:anyone:
Can anyone help me to grab a free beginners book on EXcel and Access VBA.

Zack Barresse
03-23-2009, 12:54 PM
Books aren't free. A lot of online material, however, is free. Your best bet is to take a look at the Resources page, where you'll find many helpful sites, free help boards, blogs, etc.

HTH

SWE321
12-28-2009, 03:20 AM
I recommend VBA the bible. It is almost as good as searching information from forum sucha as this one! ;)

arkusM
01-08-2010, 08:44 AM
Books aren't free. A lot of online material, however, is free. Your best bet is to take a look at the Resources page, where you'll find many helpful sites, free help boards, blogs, etc.

HTH

Sometimes books are free. :winking2:
http://www.vbaexpress.com/forum/showthread.php?t=1890

http://vbaexpress.com/forum/showthread.php?t=24408

Zack Barresse
01-10-2010, 03:42 PM
Sometimes books are free. :winking2:
http://www.vbaexpress.com/forum/showthread.php?t=1890

http://vbaexpress.com/forum/showthread.php?t=24408
LOL! Touche. :beerchug:

arkusM
01-11-2010, 06:42 AM
LOL! Touche. :beerchug:

:biglaugh:, :beerchug:

calieigh
03-09-2010, 04:25 AM
VBA won't help much if you do not master.
So you should start by learning those inside out (in interactive mode first), and do not hesitate to try them out, even with Access macros. After that, your VBA will be much simpler to write. I see too often would-be-developers spending lots of time writing code to re-create functionalities that are already built in the product.

kia101
07-10-2013, 07:26 PM
Where is a good place to purchase the books?

Aussiebear
07-17-2013, 03:31 PM
Try Amazon

Cody Wan
07-30-2014, 06:14 PM
There is at least one free VBA e-book on Amazon Kindle at the moment (i.e. July 31st)

I think it's worth a look, for beginners.

aenarios
06-05-2015, 06:42 AM
I found really usefull an online course (with written material attached) on lynda (lynda.com), it was called macros in depth or something like that! really usefull (more than just a book anyway)

Wheatly
04-10-2017, 06:48 AM
There's a few good ones on amazon but they seem very expensive sadly

Wheatly
04-10-2017, 06:51 AM
A friend of mine learnt a lot from Excel 2013 Power Programming with VBA 1st Edition by John Walkenbach. Plus if you don't like it you can refund it through kindle

Galactico
09-07-2017, 10:28 AM
some book in spanish? thanks!