Error Checking in Excel
Thanks Thanks:  0
Likes Likes:  0
Results 1 to 7 of 7

Thread: Book to learn Excel VBA?

  1. #1
    Board Regular
    Join Date
    Mar 2002
    Location
    Houston, TX
    Posts
    60
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    I am pretty good with VBA in Excel, but I have some friends that want to learn it. I have been teaching them but thought it would be good to have some suggested books, if there are any.

    So, can anyone recommend any books to learn VBA in Excel?

    TIA

  2. #2
    Board Regular
    Join Date
    Feb 2002
    Location
    Leicestershire, U K
    Posts
    160
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Larry,

    There are a number of books available.
    Best bet is to use Amazon, I have purchased a number of them. Try the reviews first to see if its what you want.

    I like VBA for Microsoft Office 2000, Its big meaty and has a cd. All for 30 squid.

    You could also try Office 97 annoyances.

    Amazon do a lot of used books as well.
    Superb value
    kk

  3. #3
    Board Regular
    Join Date
    Mar 2002
    Location
    Houston, TX
    Posts
    60
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Amazon was my first stop, I use them for everything.

    But my search for "learn excel vba" came up with a book that was panned in the recommendations. So I thought I would query this group too.

    I'll look at the book you recommend too.

    Thanks

  4. #4
    MrExcel MVP Mark O'Brien's Avatar
    Join Date
    Feb 2002
    Location
    Columbus, OH, USA
    Posts
    3,530
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    I recommend Wrox press books. Especially if Stephen Bullen has owt to do with them.

    I see Bill has recommended the Excel 2002 VBA. (except I used the XL 2000 version)

    http://www.mrexcel.com/book.shtml

    Additionally, slap in a search for Bill Jelen in amazon.com. (This site's founder)

  5. #5
    Board Regular
    Join Date
    Mar 2002
    Location
    NY
    Posts
    1,056
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    I teach from Reed Jacobson's excellent book which is appropriate for XL97 thru 2002:
    Excel 2000 Visual Basic for Applications Fundamentals

  6. #6
    Board Regular
    Join Date
    Mar 2002
    Location
    Houston, TX
    Posts
    60
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Great recommendations guys!

    Since it turns out that I will now be teaching an actual class, these will really be helpful.

    Thanks!

  7. #7
    New Member
    Join Date
    Mar 2002
    Posts
    28
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Reed Jacobson also has a good book called

    "EXCEL 2002 VISUAL BASIC FOR APPLICATIONS STEP BY STEP"

    ISBN 0-7356-1359-1

    You can get a similar version of the book for earlier versions of Excel.

    I find it very helpful.

    Dave

    [ This Message was edited by: daveray on 2002-03-28 05:50 ]

Some videos you may like

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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