Books on Excel
This page lists some of the Excel (VBA) books I like.
Excel 2007 VBA Programming For Dummies
John Walkenbach asked me whether I could help him to update this book to the 2007 version of Excel, because he was so busy doing the same for all of his other books. Of course I was honoured to do so.
This was my first experience writing a book and I must say I enjoyed it a lot.
Of course it is not up to me to write a review on this book. But what I can
do is tell you when this book might be a good buy for you:
- You're an advanced user of Excel
- You record a macro on occasion (or maybe you have never done so but are curious what this is about)
- You have little to no knowledge of VBA
To give you an idea of what is covered in this book Wiley kindly permitted me to make a chapter available for download:
Excel 2007 VBA Programming FD Sample (Chapter 2) (03 April 2007, 709k, Downloaded: 28.149 times)
Go to this books website if you want to learn more, read other people's reviews, and etcetera:
Excel 2007 VBA Programming for Dummies
Full book details:
Title: Excel 2007 VBA Programming for Dummies.
Author: John Walkenbach
Publisher: Wiley.
ISBN: 978-0-470-04674-6.
RibbonX; Customizing the Office 2007 Ribbon
An excellent work on how to work with the new Office 2007 ribbon, both from the user perspective and from the developer's. If you want to get up to speed on how you make the new Office Ribbon do what YOU want, get this book!
Find it here
Full book details:
Title: RibbonX; Customizing the Office 2007 Ribbon
Authors: Robert Martin, Ken Puls, Teresa Hennig
Publisher: Wiley.
ISBN: 978-0-470-19111-8
Excel Programming with VBA Starter
A very nice booklet for everyone who wants to jumpstart VBA programming and does not have time to wade through a 1000 page book.
Full book details:
Title: Excel Programming With VBA Starter
Authors: Robert Martin
Publisher: Packt Publishing
ISBN: 1849688443
Comments
All comments about this page:
Comment by: Edwyn (14-7-2007 14:38:55) deeplink to this comment
Great work guys. Your web site is helpful, I will be back!
Comment by: Nasser (23-12-2009 10:50:45) deeplink to this comment
Hi Karel,
I have seen also EXCEL 2007 power programming with VBA. Author John Walkenbach. Now i see another one "Excel 2007 VBA programming for dummies written by the same author. Which one is good for a beginner. I bought so far two books but they are not really what i am looking for.
Cheers,
Nasser.
Comment by: Jan Karel Pieterse (23-12-2009 11:04:59) deeplink to this comment
Hi Nasser,
I'd start with the Dummies book.
Comment by: Nasser (23-12-2009 21:20:54) deeplink to this comment
Hi Karel,
I chekced my dictionary, the word "Dummies" does not look nice :). Great i will go for it.
Thanks
Comment by: Christopher (5-10-2011 07:50:20) deeplink to this comment
Nice site.
Christopher
Comment by: Jan Karel Pieterse (5-10-2011 07:57:03) deeplink to this comment
Thanks Chris!
Comment by: Diego (2-11-2020 11:17:00) deeplink to this comment
Great article on WithEvents
I used it for my PowerPoint add-in and it worked very well with some tweaks!
Would be great to have PowerPoint VBA for Dummies as well!
cheers
Diego
Comment by: Jan Karel Pieterse (2-11-2020 13:21:00) deeplink to this comment
Hi Diego,
I'm glad this helps!
Arguably, Excel VBA for dummies does help in getting you started, if you're programming in Powerpoint VBA all that remains to be studied is the Powerpoint Object model :-)
Perhaps this site gets you started: http://www.pptalchemy.co.uk/powerpoint_hints_and_tips_tutorials.html#vba
Have a question, comment or suggestion? Then please use this form.
If your question is not directly related to this web page, but rather a more general "How do I do this" Excel question, then I advise you to ask your question here: www.eileenslounge.com.