Results 1 to 7 of 7
  1. #1
    Lounger
    Join Date
    Dec 2004
    Location
    Easley, South Carolina, USA
    Posts
    25
    Thanks
    0
    Thanked 0 Times in 0 Posts

    VBA for Excel (2000 - 2003)

    I have used Excel for a number of years but never programmed using VBA, only a few keystroke Macros. Any suggestions on books or other information for Beginning to Intermediate VBA programming?

  2. #2
    Platinum Lounger
    Join Date
    Nov 2001
    Location
    Melbourne, Victoria, Australia
    Posts
    5,016
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: VBA for Excel (2000 - 2003)

    Perhaps start with these suggestions from HansV in <post#=249920>post 249920</post#>.

    Alan

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

    Re: VBA for Excel (2000 - 2003)

    Welcome to the Lounge. See the threads within this Forum beginning with these posts:

    <post#=127027>post 127027</post#>
    <post#=180035>post 180035</post#>
    <post#=364221>post 364221</post#>

    When you have a few minutes, practice using the Search feature of the Lounge, it will often bring up old threads that will answer questions you may have. You may find some more threads on Excel VBA Help books in this Forum and in the VBA Forum.
    -John ... I float in liquid gardens
    UTC -7ąDS

  4. #4
    Gold Lounger
    Join Date
    Feb 2004
    Location
    Cape Town, RSA
    Posts
    3,444
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: VBA for Excel (2000 - 2003)

    If you are willing to buy a book, I can recommend a Microsoft press manual called "Microsoft Excel 2000 Visual Basic for Applications Fundamentals.", by Reed Jacobson. This is a teach it yourself step by step manual that comes with a CD of practice files. It is a very concise and clear step by step program that builds your knowledge from a beginner to an capable VBA programmer! Click here to see a link to the book!
    Regards,
    Rudi

  5. #5
    WS Lounge VIP sdckapr's Avatar
    Join Date
    Jul 2002
    Location
    Pittsburgh, Pennsylvania, USA
    Posts
    11,225
    Thanks
    14
    Thanked 342 Times in 335 Posts

    Re: VBA for Excel (2000 - 2003)

    You might also try the links in <post#=320321>post 320321</post#>

    Steve

  6. #6
    4 Star Lounger
    Join Date
    May 2004
    Location
    Toronto, Ontario, Canada
    Posts
    425
    Thanks
    5
    Thanked 0 Times in 0 Posts

    Re: VBA for Excel (2000 - 2003)

    Umm.....My suggestion is hang out here for a while, and do a search on VBA with google, I was surprised to see how many sites are out there for VBA.

    The Moderators here are pretty darn helpful.

    Darryl.

  7. #7
    Star Lounger
    Join Date
    Jan 2002
    Location
    Hunt Valley, Maryland, USA
    Posts
    88
    Thanks
    58
    Thanked 0 Times in 0 Posts

    Re: VBA for Excel (2000 - 2003)

    Thomas:
    Reed Jacobson has written a couple of books for Microsoft Press, one of which I received in a formal course in 2002. I still refer to it frequently, and consider it a very good work. Look for either Microsoft Excel 2000 Visual Basic for Applications Fundamentals, or same title only Excel 2002. Like many books these days, they come with a CD-ROM which contains most of the code and worksheet samples in the text.

Posting Permissions

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