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?
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.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.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.
Regards,
Patrick
I wept for myself because I had no PivotTable.
Then I met a man who had no AutoFilter.
Microsoft MVP for Excel, 2007 & 2008
no books here
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.
Regards, Zack Barresse
Check out the KB! :|: BOARD TAGS: WHAT ARE THEY AND HOW DO I USE THEM
What is a Microsoft MVP? | Free Microsoft Courses | My Book on Excel Tables
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.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.
New to the forum? Check out our Introductions section to get to know some of the members here. Feel free to tell us a little about yourself as well.
I go right for crazy ridiculousOriginally Posted by malik641
Regards,
Patrick
I wept for myself because I had no PivotTable.
Then I met a man who had no AutoFilter.
Microsoft MVP for Excel, 2007 & 2008
I tried...but then I felt crazy stupid.Originally Posted by matthewspatrick
New to the forum? Check out our Introductions section to get to know some of the members here. Feel free to tell us a little about yourself as well.
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.
Ken Puls, CMA - Microsoft MVP (Excel)
I hate it when my computer does what I tell it to, and not what I want it to.
Learn how to use our KB tags! -||- Ken's Excel Website -||- Ken's Excel Forums -||- My Blog -||- Excel Training Calendar
This is a shameless plug for my new book "RibbonX - Customizing the Office 2007 Ribbon". Find out more about it here!
Help keep VBAX clean! Use the 'Thread Tools' menu to mark your own threads solved!
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:
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.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