Nice big thick reference book

[nigelandrewfoster]

Hi. I've been programming in VBA on Excel for 5 months, and I am looking for advice as to which book to buy next. I have worked through the excellent Excel 2003 VBA Programming For Dummies, but it's not exactly comprehensive. I'm bright but no genius. Want deeper understanding of VBA programming concepts and a decent reference which gives me understanding of objects, collections and methods. Any suggestions? What's Excel VBA Power Programming by John Walkenbach like? I know the VBA help system is very good, but I struggle to read large volumes of info from the screen. Also, annotated programming examples from other users would help me unleash the power of VBA. Thanking you all in advance.

 

[RoryA]

The VBA Developers' Handbook by Getz and Gilbert (published by Sybex) is extremely good for pure VBA.
If you want Excel-orientated VBA, then the J-Walk books are good, as is the Excel 2007 VBA Programmers Reference from Wrox Press.

 

[nigelandrewfoster]

Thank you, sir. I will check those titles out. Take care. Nigel