Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Learning VBA 1

Status
Not open for further replies.

xjlkx

IS-IT--Management
Nov 21, 2002
107
US
Can someone recommend a good text to learn VBA. I have no real programming experience, but I would like to learn something that can make a contribution fairly quickly.

Thanks
 
There are many of which I use none!!
I've heard mention of John Walkebach's books more than any other on this site - can't rmember the books but his site is
Other thing to consider is using the recorder to record yourself performing some basic tasks then have a look at the code.

;-) If a man says something and there are no women there to hear him, is he still wrong?
 
xjlkx:

As Loomah stated, John Walkenbach's site includes a wealth of VBA information. I own a few of his books, and they are well written and informative, but I would not normally suggest them to a novice programmer.

I do not believe that the Tecumseh Group, Inc. allows the promotion of companies, products, services, etc. within the forums. I reviewed the current site policies, and did not locate any references with regard to answering posts, so here's my suggestion.

Please Note
I am in no way affiliated with the following product, author, or publisher and only provide it as a suggestion to answer the question at hand. [censored]

When I began learning Microsoft Excel VBA I stumbled across a wonderful book published by QUE called Using Excel Visual Basic for Applications by Elisabeth Boonin. The book was first published in 1996 covering Excel Version 7.0 for Windows 95 and has not been updated, but continues to be a great resource that will provide you with a solid beginning in programming VBA using a non-technical straightforward approach.

I also agree with Loomah that using the macro recorder is a great way to learn. Just be aware that it is not usually the shortest or best way to write a VBA program. The previously mentioned book covers this topic.

Good Luck, LoNeRaVeR
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top