Consulting

Page 2 of 2 FirstFirst 1 2
Results 21 to 39 of 39

Thread: Best book to learn VBA?

  1. #21
    Quote Originally Posted by PSL
    Hi,

    Im looking for a book to learn VBA aswell, However being a Commerce grad through and through have absolutely no prior experience with coding.

    I am able to record macro and do minor editing. But writing one from scratch.
    Only need macros for excel though..

    Any books that someone can suggest me?

    Thanks in advance
    A place to start is http://spreadsheetpage.com/
    Check out John WAlkenbach's book, listed at that web site.

    Start with the Power Programming and Formulas books.

    Also, http://www.bmsltd.co.uk/ProExcelDev/Default.htm

    A quick start, if still published, would be the MSFT Press' Excel VBA Step by Step.

  2. #22
    Fellows,
    Is there available a CD of Training, like, lynda.com for learning VBA ?
    Comments please.

  3. #23
    VBAX Mentor MaximS's Avatar
    Joined
    Sep 2008
    Location
    Stoke-On-Trent
    Posts
    360
    Location
    The best books I've ever found is www.google.com and www.vbaexpress.com/forum. First to find the reference to each function/method, second for finding ideas, solutions and testing your skills.

  4. #24
    Site Admin
    Urban Myth
    VBAX Guru
    Joined
    May 2004
    Location
    Oregon, United States
    Posts
    4,890
    Location
    Quote Originally Posted by khanjee
    Fellows,
    Is there available a CD of Training, like, lynda.com for learning VBA ?
    Comments please.
    MrExcel.com has some good resources as well for VBA examples. The CD with examples on it is very nice. I think there is a cost associated with it though.

  5. #25

  6. #26

    Can anyone help me to grab a free beginners book on EXcel and Access VBA.

  7. #27
    Site Admin
    Urban Myth
    VBAX Guru
    Joined
    May 2004
    Location
    Oregon, United States
    Posts
    4,890
    Location
    Books aren't free. A lot of online material, however, is free. Your best bet is to take a look at the Resources page, where you'll find many helpful sites, free help boards, blogs, etc.

    HTH

  8. #28
    I recommend VBA the bible. It is almost as good as searching information from forum sucha as this one!

  9. #29
    Quote Originally Posted by Zack Barresse
    Books aren't free. A lot of online material, however, is free. Your best bet is to take a look at the Resources page, where you'll find many helpful sites, free help boards, blogs, etc.

    HTH
    Sometimes books are free.
    http://www.vbaexpress.com/forum/showthread.php?t=1890

    http://vbaexpress.com/forum/showthread.php?t=24408
    Excel 2003, WinXP

  10. #30

  11. #31
    Quote Originally Posted by Zack Barresse
    LOL! Touche.
    ,
    Excel 2003, WinXP

  12. #32
    VBA won't help much if you do not master.
    So you should start by learning those inside out (in interactive mode first), and do not hesitate to try them out, even with Access macros. After that, your VBA will be much simpler to write. I see too often would-be-developers spending lots of time writing code to re-create functionalities that are already built in the product.

  13. #33
    Where is a good place to purchase the books?

  14. #34
    Moderator VBAX Guru Aussiebear's Avatar
    Joined
    Dec 2005
    Location
    Queensland
    Posts
    3,732
    Location
    Try Amazon
    Remember To Do the Following....
    Use tags when posting code to the thread,
    Mark your thread as Solved if satisfied by using the Thread Tools options.
    If posting the same issue to another forum please show the link

  15. #35
    I suggest VBA for Modelers which I have read. It is not that hard to understand.

  16. #36
    There is at least one free VBA e-book on Amazon Kindle at the moment (i.e. July 31st)

    I think it's worth a look, for beginners.

  17. #37
    I found really usefull an online course (with written material attached) on lynda (lynda.com), it was called macros in depth or something like that! really usefull (more than just a book anyway)

  18. #38
    There's a few good ones on amazon but they seem very expensive sadly

  19. #39
    A friend of mine learnt a lot from Excel 2013 Power Programming with VBA 1st Edition by John Walkenbach. Plus if you don't like it you can refund it through kindle

Posting Permissions

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