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?
Printable View
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.Quote:
Originally Posted by jumpmanjones
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.
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.
Indeed. Individual learning styles differ. Different approaches work for different apps. Different students of VBA come to the table with varying experience in programming.Quote:
Originally Posted by Howard Kaikow
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.
:dunno no books here:banghead:
We do offer training here (www.vbaexpress.com/training) but no books. You can check out some books here (http://www.mrexcel.com/sunshop/index...ion=&id=&subid)
VBA for Modelers by S. Christian Albright
This is a good book to help learn VBA.
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.
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
Scroll down towards the bottom of the page.
Definitely.Quote:
Originally Posted by Howard Kaikow
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.
I go right for crazy ridiculous :whipQuote:
Originally Posted by malik641
I tried...but then I felt crazy stupid.Quote:
Originally Posted by matthewspatrick
Hi All,
Programming.Excel.with.VBA.and.dot.NET.Apr.2006
Please check:
http://www1.7622.com/OReilly.Program...T.Apr.2006.chm
or
http://www2.7622.com/OReilly.Program...T.Apr.2006.chm
AutoCAD.2006.VBA.A.Programmers.Reference.Sep.2005
http://www2.7622.com/Apress.AutoCAD....e.Sep.2005.pdf
or
http://www1.7622.com/Apress.AutoCAD....e.Sep.2005.pdf
Good luck
kysu2tung
Hi All,
Please check the links:
Professional Excel Development : The Definitive Guide to Developing Applications Using Microsoft(R) Excel and VBA(R)
Excel 2003 VBA Programmer's Reference (Programmer to Programmer)
Access 2003 Programming by Example with VBA, XML, and ASP
Microsoft Excel VBA Programming for the Absolute Beginner, Second Edition (For the Absolute Beginner)
VB & VBA In A Nutshell
VB and VBA in a Nutshell: The Languages
Access 2003 VBA Programmer's Reference (Programmer to Programmer)
Microsoft Excel VBA Programming for the Absolute Beginner (For the Absolute Beginner (Series).)
Microsoft Access VBA Programming for the Absolute Beginner, Second Edition (For the Absolute Beginner)
Programming Excel with VBA and .NET
AutoCAD 2006 VBA: A Programmer's Reference (Programmer's Reference)
Beginning Access 2002 VBA (Programmer to Programmer)
Access VBA Programming
Mastering Excel 2003 Programming with VBA
Good luck
kysu2tung
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.
:)
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.
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, Saint Petersburg, 2005, 820 pp. (in Russian)
and it is very good book.
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.Quote:
Originally Posted by CodeMakr
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)
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/Quote:
Originally Posted by PSL
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.
Fellows,
Is there available a CD of Training, like, lynda.com for learning VBA ?
Comments please.
The best books I've ever found is www.google.com and www.vbaexpress.com/forum. First to find the reference to each function/method, second for finding ideas, solutions and testing your skills.
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.Quote:
Originally Posted by khanjee
Many thanks. :)
:anyone:
Can anyone help me to grab a free beginners book on EXcel and Access VBA.
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
I recommend VBA the bible. It is almost as good as searching information from forum sucha as this one! ;)
Sometimes books are free. :winking2:Quote:
Originally Posted by Zack Barresse
http://www.vbaexpress.com/forum/showthread.php?t=1890
http://vbaexpress.com/forum/showthread.php?t=24408
LOL! Touche. :beerchug:Quote:
Originally Posted by arkusM
:biglaugh:, :beerchug:Quote:
Originally Posted by Zack Barresse
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.
Where is a good place to purchase the books?
Try Amazon
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.
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)
There's a few good ones on amazon but they seem very expensive sadly
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
some book in spanish? thanks!