Results 1 to 8 of 8
  1. #1
    2 Star Lounger
    Join Date
    Aug 2001
    Location
    Kent, England
    Posts
    108
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Learning VBA (VBA)

    I've used excel for quite a while & consider myself very competent BUT I have never really been able to get into the VBA side of things. I've played around with recording macros & seeing what happens but that is about all.

    Basically, is there a best way of going about learning VBA to a competent degree? I think one of my main problems is actually identifying situations where VBA could be used.

  2. #2
    5 Star Lounger
    Join Date
    Dec 2000
    Location
    Reading/Swindon, Berkshire, United Kingdom
    Posts
    664
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Learning VBA (VBA)

    Basically, hanging around here for a while is pretty good way to learn, but I'd be interested to know whether <A target="_blank" HREF=http://maths.sci.shu.ac.uk/units/ioa/notes/intro.shtml>this site</A> is of any help.

  3. #3
    Gold Lounger
    Join Date
    Dec 2000
    Location
    New Hampshire, USA
    Posts
    3,386
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Learning VBA (VBA)

    The best way to learn is via an Excel VBA book.

    The 3 commonly mentioned books are by:

    1. Steve Roman (ISBN: 1565925874)
    2. John Green (ISBN: 1861002548)
    3. John WAlkenbach

    I have the first 2, have not seen the 3rd.

    Note that I have not read any of these books, but I do use them for reference for the little Excel VBA I have had to do.

    Also, check out the MSFT Press Step by Step book for Excel Visual Basic.

    In addition, some the VB and VBA books included in my Word VBA list at my URL apply equally to Excel.
    2.

  4. #4
    Gold Lounger
    Join Date
    Dec 2000
    Location
    New Hampshire, USA
    Posts
    3,386
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Learning VBA (VBA)

    Ooops, I forgot to mention

    Defijitive Guide to Excel VBA by Michael Kofler and David Kramer (ISBN: 1893115798).

    I've seen positive mention of this book.

  5. #5
    Uranium Lounger
    Join Date
    Dec 2000
    Location
    Salt Lake City, Utah, USA
    Posts
    9,508
    Thanks
    0
    Thanked 6 Times in 6 Posts

    Re: Learning VBA (VBA)

    For just getting into VBA, although it's oriented to Word, this <A target="_blank" HREF=http://mvps.org/word/FAQs/index6.html>MSMVP</A> site which was recently recommended to me should be worth your time.

    Several months ago I was pretty much in your shoes, being pretty competent with Excel but clueless about VBA. (I still have a ways to go.) I bought three books, two beginner and one reference, specific to XL VBA.

    Of these I'd recommend Julitta Korol's "Learn MS Excel 2000 VBA Programming", ISBN 1-55622-703-5, because of the relatively structured way it introduces you to concepts and code skills you will likely need. The second book I recommend is John Walkenbach's "MS Excel 2000 Power Programming with VBA" ISBN 0-7645-3263-4, which serves as a richer source of samples and goes into more detail about methods and properties, BUT assumes you already have an understanding of VBA objects, methods and properties (and at times I feel that in the later chapters it assumes you have some coding background). The third book I bought is Walchenbach's "Excel 97 Programming for Dummies" (title?); while it's good, I wouldn't recommend it because it's less structured, and skips some things, but also because it's a condensation of his "... Power Programming with VBA"; many paragraphs in many of the chapters are verbatim duplicates!

    Finally, the lounge is very welcoming of beginner VBA questions; they tolerated mine pretty well! (Well, I -think- they did.)

    HTH.
    -John ... I float in liquid gardens
    UTC -7ąDS

  6. #6
    5 Star Lounger jujuraf's Avatar
    Join Date
    Jun 2001
    Location
    San Jose, California, USA
    Posts
    1,061
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Learning VBA (VBA)

    Someone already listed three books. I would highly recommend the Walkenbach book as it taught me most of what I know and it's great. I have two copies one at home one at work and both are well worn with notes and stickies. So Walkenbach is my first choice if you just buy one book, then John Green's book. I personally don't tend to like any MS Press books as usually they're rehashes of the help files with little background info. The Step-by-Step series is okay for raw beginners and if you've never recorded macros but it doesn't contain any real substance or reasons for why you're doing things. if you can find a used one it might be worth it as a start, but I wouldn't buy a new copy for such a simplistic book.

    There are only a handful of books on VBA where as there are millions on VB. If you have an previous experience w/any other programming language, then picking up another is much easier. Since you know Excel so well, once you get over the basics of how VBA works, it should come easy to you.

    Good luck.
    Deb <img src=/S/grin.gif border=0 alt=grin width=15 height=15>

  7. #7
    Plutonium Lounger
    Join Date
    Dec 2000
    Location
    Sacramento, California, USA
    Posts
    16,775
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Learning VBA (VBA)

    If you want a good reference (not the best place to learn a new language though), try the Visual Basic Language Developer's Handbook (Sybex), by Ken Getz and Mike Gilbert.

    This includes the an appendix, "borrowed" from the Access 2000 Developer's Handbook: Desktop Edition, introducing using the WinAPI in VBA applications, plus 1000+ pages of expert (and very useful) code. Don't be mislead by the title, because VBA is the language part of Visual Basic as well, so the code is pretty portable and not really specific to any one Office application.
    Charlotte

  8. #8
    2 Star Lounger
    Join Date
    Aug 2001
    Location
    Kent, England
    Posts
    108
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Learning VBA (VBA)

    Thanks Guys (& Gals),

    I shall be convincing my boss to purchase some books!

    The sites look quite helpful too

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •