Books on Excel

This page lists some of the Excel (VBA) books I like.

Excel 2007 VBA Programming For DummiesExcel 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: 27.303 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 RibbonRibbonX; 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 StarterExcel Programming With VBA Starter (Cover)

A very nice booklet for everyone who wants to jumpstart VBA programming and does not have time to wade through a 1000 page book.

Find this book at Packtpub

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.




To post VBA code in your comment, use [VB] tags, like this: [VB]Code goes here[/VB].