The ultimate Reference Guide to VBA in Excel

[Guest]

I am looking for a comprehensive tutorial og reference for VBA code in Excel.
I work in consultancy firm, where we use vba for modelling (health economic
analysis) and for creation of user friendly interfaces to our models.

Is there anyone out there who know the book that says it all?

 

[Tom Ogilvy]

for VBA for Excel
http://www.oaltd.co.uk/ProExcelDev/Default.htm

Also look at:
http://www.oaltd.co.uk/ExcelProgRef/Default.htm

or
go to John Walkenbach's site and look at his POWER PROGRAMMING series (same
book updated for newer releases)
http://www.j-walk.com/ss/books/index.htm

 

[Guest]

There are lots of good books out there... Are you looking for a good
reference book or a good learning book. Reference book are normally for
experienced users who want a reference to help them solve very specific
problems. A learning book is more of a step by step how too, which teaches
the reader increasingly complex issues.

 

[Guest]

I would imagine a book that "says it all" would be quite large and probably
not all that useful. Nonetheless, one of the more useful books that I have
come across is John Walkenbach's "Excel ???? Power Programming with VBA".
(Insert a version name where the ????'s are located). Another useful book is
"VB & VBA in a Nutshell", written by Paul Lomax and published by O'Reilly &
Associates. For general programming tasks, these 2 references suit me fine.
The first book is more of a "how-to" book and shows you how to create custom
menus, user forms, interact with other applications, work with charts, etc,
while the second is more of a reference manual that addresses VBA language
elements (statements, procedures, functions, etc.). For more advanced
programming, I imagine there are other good books out there.

Jim

 

[Guest]

You are right - I need both - but mostly a reference book

 

[Guest]

Thank you - Power Programming with VBA sounds good!

 

[Guest]

Thank you for your advice - maybe Excel 2002 VBA Programmer's Reference
plus Walkenbachs Power Programming together will meet my needs.

 

[John in Surrey]

On Wed, 8 Feb 2006 11:20:31 -0800, "Martin Knudsen"
amazon has second hand books in the UK, you may get a title cheap from
amazon.co.uk
worth it for the reviews
Images of home (NZ)
http://www.titahi-bay.co.nz/home
What we are up to in the UK
http://www.titahi-bay.co.nz