As im starting to move more towards Macro's and commands that ultimatly are
more useful than normal formulas in cells, I find myself needing to know
something about VBA.

Currently I want to press a button have some information copied to a certain
cell dependant on today's date, but I have no idea how to get it to look at
cell D23 if cell H41 has 23 in it. Also I will need the sheet to have a
button that opens a sheet and copies some information from it, the only
trouble with this is that the file that needs opening will be a different
name each day....

It all generally leads me to wanting to know more about VBA, my general
coding experience is low, and most of the stuff in VBA looks like a load of
random characters to me.

Are there any books/websites that can help me get to grips to having VBA do
what I want? I learn't most of what I do in excel by having a look at the
functions and their helpfiles.

I would recommend 2 books by Microsoft Press, one written for Excel 2000 and
the other for Excel 2003:

Excel 2000 Visual Basic for Applications Step by Step
Reed Jacobson

This is an excellent instructional tool in programming basics, with each
chapter a stand-alone lesson.

Excel 2003 Programming
Curtis Frye, Wayne Freeze & Felicia Buckingham

This too is a great instructional guide to programming, and each chapter is
a stand-alone lesson as well, but it has additional detail information that
is highly beneficial

Both book come with CD that contains the lesson files. I've had an
opportunity to use both books in a classroom setting and both are excellent
learning tools.
--
Kevin Backmann


"PaulW" wrote:

As im starting to move more towards Macro's and commands that ultimatly are
more useful than normal formulas in cells, I find myself needing to know
something about VBA.

Currently I want to press a button have some information copied to a certain
cell dependant on today's date, but I have no idea how to get it to look at
cell D23 if cell H41 has 23 in it. Also I will need the sheet to have a
button that opens a sheet and copies some information from it, the only
trouble with this is that the file that needs opening will be a different
name each day....

It all generally leads me to wanting to know more about VBA, my general
coding experience is low, and most of the stuff in VBA looks like a load of
random characters to me.

Are there any books/websites that can help me get to grips to having VBA do
what I want? I learn't most of what I do in excel by having a look at the
functions and their helpfiles.