Loading
Ozgrid Excel Help & Best Practices Forums

Excel Video Tutorials / Excel Dashboards Reports



Results 1 to 8 of 8

Thread: Vba Book Suggestion

  1. #1
    Join Date
    18th January 2008
    Posts
    12

    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?

    Excel Video Tutorials / Excel Dashboards Reports


  2. #2
    Join Date
    25th July 2006
    Posts
    124

    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.

    Excel Video Tutorials / Excel Dashboards Reports


  3. #3
    Join Date
    15th April 2003
    Location
    USA
    Posts
    7,396

    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.

  4. #4
    Join Date
    20th February 2006
    Location
    London, UK
    Posts
    2,977

    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.

    Excel Video Tutorials / Excel Dashboards Reports


  5. #5
    Join Date
    18th January 2008
    Posts
    12

    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?

    Excel Video Tutorials / Excel Dashboards Reports


  6. #6
    Join Date
    25th July 2006
    Posts
    124

    Re: Vba Book Suggestion

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

    Excel Video Tutorials / Excel Dashboards Reports


  7. #7
    Join Date
    18th September 2005
    Location
    Hampshire, UK
    Posts
    1,278

    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

    Excel Video Tutorials / Excel Dashboards Reports


  8. #8
    Join Date
    12th September 2010
    Posts
    1

    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.

    Excel Video Tutorials / Excel Dashboards Reports


Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Possible Answers

  1. Copy Data From Book To Book Error
    By Addy in forum EXCEL HELP
    Replies: 11
    Last Post: June 22nd, 2007, 21:46
  2. A Suggestion to Improve the Forum
    By xlite in forum HAV-A-CHAT
    Replies: 0
    Last Post: September 9th, 2006, 12:39
  3. VB suggestion
    By Excel_VBA_kid in forum EXCEL HELP
    Replies: 2
    Last Post: April 1st, 2005, 08:25
  4. Suggestion requested for the best solution
    By Joozh in forum EXCEL HELP
    Replies: 3
    Last Post: May 27th, 2003, 05:27
  5. Need Suggestion
    By hhfei in forum EXCEL HELP
    Replies: 7
    Last Post: March 26th, 2003, 14:13

Bookmarks

Posting Permissions

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