Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
The ultimate Reference Guide to VBA in Excel
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? |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
The ultimate Reference Guide to VBA in Excel
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 -- Regards, Tom Ogilvy "Martin Knudsen" <Martin wrote in message ... 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? |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
The ultimate Reference Guide to VBA in Excel
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. -- HTH... Jim Thomlinson "Martin Knudsen" wrote: 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? |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
The ultimate Reference Guide to VBA in Excel
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 "Martin Knudsen" wrote: 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? |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
The ultimate Reference Guide to VBA in Excel
You are right - I need both - but mostly a reference book
"Jim Thomlinson" wrote: 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. -- HTH... Jim Thomlinson "Martin Knudsen" wrote: 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? |
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
The ultimate Reference Guide to VBA in Excel
Thank you - Power Programming with VBA sounds good!
"Jim Hagan" wrote: 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 "Martin Knudsen" wrote: 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? |
#7
Posted to microsoft.public.excel.programming
|
|||
|
|||
The ultimate Reference Guide to VBA in Excel
Thank you for your advice - maybe Excel 2002 VBA Programmer's Reference
plus Walkenbachs Power Programming together will meet my needs. "Tom Ogilvy" wrote: 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 -- Regards, Tom Ogilvy "Martin Knudsen" <Martin wrote in message ... 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? |
#8
Posted to microsoft.public.excel.programming
|
|||
|
|||
The ultimate Reference Guide to VBA in Excel
On Wed, 8 Feb 2006 11:20:31 -0800, "Martin Knudsen"
wrote: 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Is there a quick reference guide for excel 2003 -2007 | Excel Discussion (Misc queries) | |||
Reference Guide for Creating Formulas | Excel Discussion (Misc queries) | |||
Reference Guide | Excel Discussion (Misc queries) | |||
Documentation/Reference guide | Excel Programming | |||
Good VBA reference guide | Excel Programming |