Thread: 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?

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 Knudsen@discussions.microsoft.com> wrote in message
news:1C1729F2-A6AF-4CE1-8A4F-88E8DBB1136E@microsoft.com...
> 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?
>
>

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?
>
>

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?
>
>

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?
> >
> >

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?
> >
> >

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 Knudsen@discussions.microsoft.com> wrote in message
> news:1C1729F2-A6AF-4CE1-8A4F-88E8DBB1136E@microsoft.com...
> > 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?
> >
> >
>
>
>

On Wed, 8 Feb 2006 11:20:31 -0800, "Martin Knudsen"
<MartinKnudsen@discussions.microsoft.com> 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