Logo 
Search:

MS Office Forum

Ask Question   UnAnswered
Home » Forum » MS Office       RSS Feeds

Learning VBA/macros from scatch

  Asked By: Eden    Date: Oct 07    Category: MS Office    Views: 2338
  

I need help to learn VBA. I use excel and word everyday at work, but my
work now demands that I learn macros/VBA as a matter urgency. Since I am new
to this stuff, I wish to start from scatch.

Share: 

 

6 Answers Found

 
Answer #1    Answered By: Lurline Fischer     Answered On: Oct 07

It looks like you used an old post and did a reply to it.
Please... For future reference... Zap the Re: ... I garuntee you'll get more
answers because people won't get mad wasting time looking for an original!!
:-)

There are lots of ways to do what you want... Books... Private tuition...
Courses... Paid for internet courses... Free internet tutorials... Self
taught... Lots. All of it googalable.

Do you have a budget? Buying and working through books is one of the
favourite options.
I don't have any recomendations gor books but I'm positive some people here
have. C'mon you VBAers!!!!

I would suggest though that you have a project to work  on. It could even be
as simple as building an address book with input output and editing... But
having something to aim for concentrates the learning  provess incredibly.
Why do need it so urgently for example? Is it for a specific project?

Another great font of knowledge is the "Macro" ... IMHO a misnomer...
Recorder.
You want to do something?... Record doing it manually.. Hit F11 and see how
microsoft coded it up.

 
Answer #2    Answered By: Alfonsine Miller     Answered On: Oct 07

I now need to learn  VBA becuase there jobs that I cannot get when I do not know
how to use macros/VBA etc.
I am keen to use the free internet tutorials and self help  for a start,may be
buy books later on after making sense of it.

If you could help me with the sources for free internet access.

 
Answer #3    Answered By: Fedde Bakker     Answered On: Oct 07

But meanwhile why not check out the tutorial series right here on TechTrax
by Mark Thorpe called "No experience nessesary".

pubs.logicalexpressions.com/.../LPMArticle.asp

 
Answer #4    Answered By: Taylor White     Answered On: Oct 07

Two essentials:

-- The macro recorder can give you some idea of things that can be done.
-- Google is your friend.

 
Answer #5    Answered By: Cay Nguyen     Answered On: Oct 07

Since I do not have often the occasion to solve others problems,
because I too am learning  from scratch, I will recommend this book to
you, that was recommended to me from this group some time ago.
Excel 2002 Power Programming with VBA, by John Walkenbach. that comes
with a CD with examples.
(Google the author's name, he has written lots of other books)
And it's true that if you search through the posts of this group,
you'll find some answers.

This book helped me a lot to start  with!

And as for Google, this book might also help  you to find the right
words to search for.
Because when one starts from scratch, one does not even know what to
type in Google's search line.

And try to read as many posts from this group as possible: when
you'll understand what there talking about, you'll know you have
progressed a lot :-)

And talking of Google, type Visual basic Excel and search in groups.
You might find a few where members will answer more basic questions
then this one.
They have helped me a lot when I just came, but now, it seems that
they are looking for bigger challenges then what we beginners can ask
for.

I spend many hours a day, and done subs that work  pretty well, but
that are certainly not very "elegant" from a real programmer point of
view.
Once I master what's in that book, I guess I'll try to find another
one, because the examples are sometimes too elementary.
Recording macros and looking at the code also helps to start with.
But there are things the recorder simply never makes.

 
Answer #6    Answered By: Corbin Jones     Answered On: Oct 07

As a beginner in VBA do you also mean that you are a beginner in
programming? If yes then just starting to learn  VBA is like starting to
learn any programming language and would require that you have to
understand some logic on writing programs. I do not mean the high level
stuff like pointer arithmetic or data structures but the simple stuff  like
sorting algorithms, or using decision statements, string manipulations
etc.

If no then Walkenbach is good. Also books by Curtis Frye and books on
Excel 200X Inside Out series are good.

A really good book is Writing excel  macros with VBA by Steven Roman
(Oreilly). An important feature of this book unlike the other books is
that he discusses the Excel object model in detail.

Websites which could help  you out are www.ozgrid.com,
www.techonthenet.com, www.mrexcel.com.

If you are planning on becoming good at excel career wise try not to use
the recorder very often. Try to understand the Excel object model.

 
Didn't find what you were looking for? Find more on Learning VBA/macros from scatch Or get search suggestion and latest updates.




Tagged: