A beginner of VBA, need to learn it!

Question

A beginner of VBA, need to learn it!

struclearner (Structural)

(OP)

21 Jun 10 00:26

Dear all:

I am a novice to programming, want to start from VBA. I need advice, from where I should start. I started to read a book, but realized that there is need to start from basics, particularly from the terms used and their meaning.
Any help regarding refrerencing to ay material on the web or recommendation of any book explaining from the very start & basics will be appreciated.

IRstuff (Aerospace) · Answer 1 · 2010-06-21 01:35:54

The best approach is to figure a project that you need done and then go do it. Anything else would be too artificial and you'd still have to do a real project at the end of it.

TTFN

FAQ731-376: Eng-Tips.com Forum Policies

Denial (Structural) · Answer 2 · 2010-06-21 05:02:35

The book I used, and still use from time to time, was the "For Dummies" book authored by John Walkenbach. It was called "Excel 97 Programming for Windows for Dummies".

I do not think it is available new any more, so try for a second hand copy. IMHO its successor books (for later versions of Excel and by a different authors) were aimed at people somewhat less dummy than me.

satchmo (Mechanical) · Answer 3 · 2010-06-21 07:20:03

You can learn some syntax basics in Excel by recording a macro, then looking at the code in the VB editor. I figured out a lot of stuff that way.

fmr110 (Mechanical) · Answer 4 · 2010-06-21 16:09:15

I learned the same way as Satchmo. Record macros and study them carefully as you record them.

Also try googling what you need to do.. I'm pretty sure everything you need to know is free on the internet already.

pracslipkerm (Mechanical) · Answer 5 · 2010-06-21 16:53:06

I also learnt by recording macro's and also from downloading samples that did close to what I wanted and modifying them. Best thing is to have something you want to do and keep trying until you get it!!!

Cheers
Steve Griffiths

If you want to make apple pie from scratch, first you must create the universe!

MiketheEngineer (Structural) · Answer 6 · 2010-06-21 19:03:12

You might want to visit the sister site of this one "Tek-tips.com". All the computer geeks are over there and they have a wealth of info and are also very helpful

struclearner (Structural) · Answer 7 · 2010-06-21 20:07:30

Dear All,

I am grateful for all of your time and valuable advices. I am waiting for the book as mentioned by Denial and will go through the Macro recording stratergy as well.

Regards & Thanks

xwb (Computer) · Answer 8 · 2010-07-09 01:27:44

I found the best way to learn is to put excel in record mode and then do whatever you wish. Stop the recording and look at the generated code.

It can then be optimized to do whatever you want. You can do this for all the office tools.

Come Join Us!

Posting Guidelines

A beginner of VBA, need to learn it!