Announcement

Collapse
No announcement yet.

Unconfigured Ad Widget

Collapse

Vba Book Suggestion

Collapse
X
  • Filter
  • Time
  • Show
Clear All
new posts

  • Vba Book Suggestion

    I am somewhat new to VBA. I have culled some information here and there from this forum. It has given me a general beginning understanding of a few vba functions. However, I would like to purchase a VBA book that can possibly do 2 things:

    1) Walk me through step-by-step how to use and implement some common and helpful VBA functions. (I am a quick learner, so it doesn't have to be too basic, but not too advanced in that it doesn't actually tell me how to implement anything).

    2) Serve well as a reference book (not just a tutorial).

    Anyone have any suggestions?

  • #2
    Re: Vba Book Suggestion

    I've been going through Excel 2007 Power Programming with VBA by John Walkenbach. It starts out with the basics of VBA, but covers a lot of ground. It also has several appendices at the back that make a good reference and a CD with workbooks showing the code in the book at work. There's a version for Excel 2003 as well.

    Comment


    • #3
      Re: Vba Book Suggestion

      I agree that Walkenbach books mentioned by darkyam are excellent intermediate books to learn VBA and the appropriate one should serve both your purposes.
      Please do not U2U (private message) me directly for questions that should be posted to the forum; any such U2Us will be ignored.

      Comment


      • #4
        Re: Vba Book Suggestion

        If you want another recommendation I've used "Excel 2002 VBA: Programmers Reference" and found it useful. I think there are various versions. Can't remember the authors' names apart from a Mr Bullen.

        Comment


        • #5
          Re: Vba Book Suggestion

          Great, thanks guys!

          And just for clarification, most of these lines of books should have one relevant for Excel 2003 (which is what I'm using), correct?

          Comment


          • #6
            Re: Vba Book Suggestion

            Both the book I suggested and StephenR's have a 2003 version.

            Comment


            • #7
              Re: Vba Book Suggestion

              But don't buy the xl2003 VBA Programmer's Reference as Bullen, Bovey and Green (those behind the 2002 version) weren't involved in the production of the 2003 version (and it's consequently nowhere near as good). All the xl2002 stuff will apply to xl2003, so you won't be losing anything (much) by going for the 2002 version.

              I personally think the Walkenbach book is better for a beginner though

              Comment


              • #8
                Re: Vba Book Suggestion

                I agree,I have the Walkenbach book and it is even understandable for me,being a newb.

                edit,Just saw this thread is from more than 2 years ago :P ,doesn't make the book less good ofc.

                Comment


                • #9
                  Re: Vba Book Suggestion

                  But don't buy the xl2003 VBA Programmer's Reference as Bullen, Bovey and Green (those behind the 2002 version) weren't involved in the production of the 2003 version (and it's consequently nowhere near as good). All the xl2002 stuff will apply to xl2003, so you won't be losing anything (much) by going for the 2002 version.

                  I personally think the Walkenbach book is better for a beginner though






                  ____________________
                  Johni...
                  https://www.apple.com/
                  http://www.pass4-sure.net/640-792-dumps.html
                  http://www.washington.edu/
                  http://en.wikipedia.org/wiki/Exin
                  https://www.facebook.com/authorized.apple

                  Comment

                  Trending

                  Collapse

                  There are no results that meet this criteria.

                  Working...
                  X