Advice for a newbie

[DavidObeid]

Hi,

I discovered www.exceltip.com by accident a few weeks ago and have
improved in my work on excel a zillion %. Thanks a heap.

My question is about learning VBA from scratch.

I (used to) know Pascal reasonably well and understand the basic
principles of programming.

What I want to know is where can I go to learn VBA for Excel so that I
can do even more with Excel? I have a few ideas for different
programs, but I am getting bogged down trying to work out details like
syntax etc.

Is there a "Programming in VBA for Excel for dummies" type book out
there? Is it possilbe that someone here has a URL with the basics on
it? (I don't just want examples, I would like something that explained
some of the theory behind the examples).

Thanks in advance for your help.

Dave

 

[Edwin Tam (MS MVP)]

For someone new to Excel VBA, I always recommend the book from Microsoft Press
Microsoft® Excel 2002 Visual Basic® for Applications Step by Step by Reed Jacobso

This is a best book for someone who want to start using Excel VBA
It's concise, systematically arranged. The book is divided into lessons, with good examples and tutorial files

In fact, the same Step by Step book from Reed Jacobson was the first book I read when I first encountered Excel VBA. (It was Excel 5?

Read that book, and frequently refer to the Excel VBA on-line help, and you'll be able to master in Excel VBA. That's all you need

 

[Italian Job]

Or "Microsoft Excel 2000 Power Programming with VBA", by John Walkenbach