Results 1 to 6 of 6
  1. #1
    2 Star Lounger
    Join Date
    Apr 2001
    Location
    Vancouver, Canada
    Posts
    131
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Book of VBA Code (Excel 2000 SR1)

    Can anyone recommend a good book that contains lots of VBA code that I could learn from? or a site on the net?

    Thanks,

    Christa

  2. #2
    4 Star Lounger
    Join Date
    Jan 2001
    Location
    Kortrijk, Belgium
    Posts
    571
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Book of VBA Code (Excel 2000 SR1)

    Have a look at for a very good website. I also recommend John Walkenbach's books for beginners and more advanced programmers. See <A target="_blank" HREF=http://www.j-walk.com> John's website . Also John Green (Can't remember the title) and Michael Kofler (Definitive Guide to Excel VBA) have a very good book for more experienced VBA programmers. You can find them at www.Amazon.com.

  3. #3
    Uranium Lounger
    Join Date
    Jan 2001
    Location
    South Carolina, USA
    Posts
    7,295
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Book of VBA Code (Excel 2000 SR1)

    This site has lots of code and is about as good as they get.
    Legare Coleman

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

    Re: Book of VBA Code (Excel 2000 SR1)

    Here's some threads with some useful discussion on Internet resources and books , <A target="_blank" HREF=http://www.wopr.com/cgi-bin/w3t/showflat.pl?Cat=&Board=vb&Number=103370>VBA 103370, <A target="_blank" HREF=http://www.wopr.com/cgi-bin/w3t/showflat.pl?Cat=&Board=xl&Number=51549>Excel 51549</A>.

    If you have programming experience, you might want to look at VB and VBA in a Nutshell: The Languages by Paul Lomax, O'Reilly Press ISBN: 1565923588, or Visual Basic Language Developer's Handbook (Sybex), by Ken Getz and Mike Gilbert ISBN: 0782129781.
    -John ... I float in liquid gardens
    UTC -7ąDS

  5. #5
    Platinum Lounger
    Join Date
    Feb 2001
    Location
    Weert, Limburg, Netherlands
    Posts
    4,812
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Book of VBA Code (Excel 2000 SR1)

    Hi Hans,

    <<Can't remember the title>>

    Excel 2002 VBA Programmer's Reference

    Find it at:

    <A target="_blank" HREF=http://www.wrox.com/Books/Book_Details.asp?sub_section=1&isbn=1861005709&sub ject=VBA&subject_id=6>http://www.wrox.com/Books/Book_Details.asp...mp;subject_id=6</A>

    An absolutely excellent book.
    Jan Karel Pieterse
    Microsoft Excel MVP, WMVP
    www.jkp-ads.com
    Professional Office Developers Association

  6. #6
    Silver Lounger
    Join Date
    Mar 2001
    Location
    Springfield, Ohio, USA
    Posts
    2,136
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Book of VBA Code (Excel 2000 SR1)

    I'm a Steven Roman fan. His is still on sale at Amazon for $21 and is definitely the best buy. See <A target="_blank" HREF=http://www.wopr.com/cgi-bin/w3t/showflat.pl?Cat=&Board=vb&Number=103370&page=&view =&sb=&o=&vc=1>this thread for more details. Legare is correct: Woody's Lounge is the best <img src=/S/love.gif border=0 alt=love width=15 height=15> site for code.
    <font face="Comic Sans MS">Sam Barrett, CACI </font face=comic>
    <small>And the things that you have heard... commit these to faithful men who will be able to teach others also. 2 Timothy 2:2</small>

Posting Permissions

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