Consulting

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

Thread: Best book to learn VBA?

  1. #21
    VBAX Mentor
    Joined
    Sep 2004
    Location
    Nashua, NH, USA
    Posts
    489
    Location
    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
    VBAX Newbie
    Joined
    Dec 2008
    Posts
    2
    Location
    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,940
    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
    VBAX Newbie
    Joined
    Dec 2008
    Posts
    2
    Location
    Many thanks.

  6. #26
    VBAX Newbie
    Joined
    Mar 2009
    Posts
    1
    Location

    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,940
    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
    VBAX Regular arkusM's Avatar
    Joined
    May 2007
    Location
    Calgary
    Posts
    52
    Location
    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
    VBAX Regular arkusM's Avatar
    Joined
    May 2007
    Location
    Calgary
    Posts
    52
    Location
    Quote Originally Posted by Zack Barresse
    LOL! Touche.
    ,
    Excel 2003, WinXP

  12. #32
    Banned VBAX Newbie
    Joined
    Mar 2010
    Posts
    1
    Location
    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
    VBAX Regular
    Joined
    Jul 2013
    Posts
    10
    Location
    Where is a good place to purchase the books?

  14. #34
    Moderator VBAX Guru Aussiebear's Avatar
    Joined
    Dec 2005
    Location
    Queensland
    Posts
    4,967
    Location
    Try Amazon
    Remember To Do the Following....
    Use [Code].... [/Code] 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
    VBAX Newbie
    Joined
    Jul 2014
    Posts
    1
    Location
    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.

  16. #36
    VBAX Newbie
    Joined
    Jun 2015
    Posts
    2
    Location
    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)

  17. #37
    VBAX Regular
    Joined
    Apr 2017
    Posts
    6
    Location
    There's a few good ones on amazon but they seem very expensive sadly

  18. #38
    VBAX Regular
    Joined
    Apr 2017
    Posts
    6
    Location
    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

  19. #39
    some book in spanish? thanks!

Posting Permissions

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