Is it possible to teach ones self VBA?
Hi, Ron. Yes, it is possible to become self-taught. I have done exactly
that. Except what I taught myself was nowhere near as useful as what the
good people here on the newsgroup have taught me.
A few ideas:
(1) Pick a real issue to work through. That way, you know if you have real
results. If you don't have one at the moment, look at some of the questions
posted here. Set it up and figure out how you would work through it.
(2) Do a Google search of the newsgroups to find previous posts and
solutions. Try to work your way through the answers and understand both why
and how, not just memorize or steal bits of code.
(3) Use the macro recorder to create your own macros, then look at the code
created. It'll give you some ideas of what code looks like and how it flows
(though not what *good, streamlined* code looks like - the recorder throws
everything AND the kitchen sink!).
(4) Try comparison shopping on the 'net for some good reference books.
I've gotten $45 and $60 books for less than half - brand new!
(5) Try some things and have fun making a few mistakes. (Just make sure
you have backups of anything important! Better yet - don't experiment on
real data!)
HTH
Ed
PS - VB6 and VBA are NOT the same thing! VB6 creates stand-alone programs,
while VBA is the macro language packaged with the application and specific
to the application object model.
"Ron" wrote in message
10.130...
Hello all,
Firstly let me thank all the experts who give their time and replies
freely
to this forum/newsgroup.
I'm wanting/willing to learn VB6/VBA, but personal circumstances dictate
that I cannot enroll for college courses. I live far from major colleges
and my local college doesn't go anywhere near programming.
I'm willing to buy books but am loathe to pay high prices for information
that isn't useful to me.
Is it possible to be an expert at VBA and be totally self taught?
If so, can anyone reccomend any books/courses that will take a beginner
forward?
Regards,
Ron
|