View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Gord Dibben Gord Dibben is offline
external usenet poster
 
Posts: 22,906
Default Reading Material: Excel VBA

Peter

Anything from John Walkenbach would be considered excellent.

See a list of those and others here at Debra Dalgleish's site.

http://www.contextures.on.ca/xlbooks.html


Gord Dibben MS Excel MVP

On Sat, 10 Mar 2007 20:58:05 -0000, "Peter W Soady \(UK\)"
wrote:

Hi

Can anyone please recommend a book or books for Excel (or all) VBA
programming please.

I can use the Excel "Record Macro" without any problems and can get some
quite complex code to run and work correctly, but, I need to be able to do a
lot more with it than the "Record Macro" allows. I have included a few
examples of what I need to do:

Query the entire worksheet for data then I have input from an input box.
Conditionally format a cell from the query result
Transfer the complete column (or row) into a pre defined template

These are just a few items and I really need a good book on VBA to allow
this to happen