On Mon, 4 Jul 2005, John Pearson wrote:
> I need to do some macros in Excel. Am I correct in assuming that I 
> should learn VBA to do this?

Yes, if you have any recent version of Excel

> If so, can anyone recommend a good book for begginers VBA.

There is an old O'Reilly book you might find, "Writing Excel Macros."

John Walkenbach has also written a number of books on Excel and VBA,
his books tend to copy the bulk of what he has written before.

There is a new thick book out this year on Excel VBA but I can't
find the title here at the moment.

> Things I will want to do is to be able to place some values that will 
> arrive in A1 through D1 into other cells, to form a list. I will also 
> like to be able to visually graph the data that is arriving and being 
> placed into other cells in real time. Is this doable with VBA?

"Arrays" in macros are feasible.  Sometimes there are even shreds of
documentation on them.  Sometimes they act in very opaque fashions.

Array parameters and functions returning arrays can be more challenging.
I struggled for a while with a project that was doing 3-d geometry,
arrays, vectors, dot, cross, norm, etc.  It can be done but there can
be a lot of head scratching and occasional deadends.

"real time" I've never even considered doing with Excel/VBA.

Sometimes the microsoft.public.excel.programming newsgroup can be of
assistance, either searching old postings or when that doesn't work
asking new questions.

Toss me mail if you like, I'll tell you what I know and what I don't.
-- 
http://www.piclist.com PIC/SX FAQ & list archive
View/change your membership options at
http://mailman.mit.edu/mailman/listinfo/piclist