Results 1 to 6 of 6

Learn VBA

This is a discussion on Learn VBA within the General Excel Discussion & Other Questions forums, part of the Question Forums category; Hi, This is Rahul and i want to start learning excel macros. Can anybody please guide me how should i ...

  1. #1
    New Member
    Join Date
    Nov 2012

    Default Learn VBA

    Hi, This is Rahul and i want to start learning excel macros. Can anybody please guide me how should i go about it.

    Awaiting your reply. Thanks!

  2. #2
    VoG is offline
    MrExcel MVP
    VoG's Avatar
    Join Date
    Jun 2002
    HTH, Peter
    Please test any code on a copy of your workbook.

  3. #3
    MrExcel MVP
    Smitty's Avatar
    Join Date
    May 2003
    Crested Butte, CO

    Default Re: Learn VBA

    Welcome to the Board!

    I'd start by playing with the macro recorder performing tasks with which you're familiar, then read the code and you'll start getting an idea of what it's doing.

    Feel free to post what you come up with and someone can explain it and help you clean it up, as recorded code isn't always the most efficient, but it's a great place to start.


    Every once in a while, there's a sudden gust of gravity...

    Check out my new book at the Mr. Excel Bookstore!

    Mr. Excel HTML Maker - Post a shot of your sheet

  4. #4
    Board Regular Michael M's Avatar
    Join Date
    Oct 2005
    Western NSW

    Default Re: Learn VBA

    As well as what the guys above have posted, have a look here for a handy list of tutorials / sites / books, etc that may help, kindly compiled by Hiker95
    Training / Books / Sites as of 05/21/2012
    MrExcel's Products: Books, CDs, Podcasts Discuss topics related to Holy Macro! Products: Learn Excel from MrExcel, VBA and Macros for Microsoft Excel,Holy Macro! It's 2500 VBA Examples CD, Guerilla Data Analysis Using Microsoft Excel and Excel Knowledge Base CD and the MrExcel Podcasts.
    There are over 1800 Excel videos/tutorials here:
    Getting Started with VBA.
    If you are serious about learning VBA try
    Excel Tutorials and Tips - VBA - macros - training
    Here's a good primer on the scope of variables.
    Scope Of Variables And Procedures
    See David McRitchie's site if you just started with VBA
    What is a Visual Basic Module?
    Ron de Bruin's intro to macros:
    Creating An XLA Add-In For Excel, Writing User Defined Functions In VBA
    How do I create a PERSONAL.XLS(B) or Add-in
    Creating custom functions
    Writing Your First VBA Function in Excel
    VBA for Excel (Macros)
    VBA Lesson 11: VBA Code General Tips and General Vocabulary
    Excel VBA -- Adding Code to a Workbook
    Learn to debug:
    How To: Assign a Macro to a Button or Shape
    User Form Creation
    When To Use a UserForm & What to Use a UserForm For
    Excel Tutorials / Video Tutorials - Functions
    INDEX MATCH - Excel Index Function and Excel Match Function
    Excel Data Validation
    Your Quick Reference to Microsoft Excel Solutions
    New! Excel Recorded Webinars
    Programming The VBA Editor - Created by Chip Pearson at Pearson Software Consulting LLC
    This page describes how to write code that modifies or reads other VBA code.
    VBA and Macros for Microsoft Excel, by Bill Jelen "Mr.Excel" and Tracy Syrstad
    Excel Hacks 100 Industrial-Strength Tips & Tools, by David & Traina Hawley
    VBA and Macros for Microsoft Excel 2007, by Bill Jelen "Mr.Excel" and Tracy Syrstad
    Excel 2007 Book: you can try this...there is a try before you buy ebook available at this linků
    by Stephen/ Bovey, Rob/ Green, John Bullen (Paperback - Feb 11, 2005)
    Professional Excel Development
    by Rob Bovey, Stephen Bullen, John Green, and Robert Rosenberg (Paperback - Sep 26, 2001)
    Excel 2002 VBA: Programmers Reference
    DonkeyOte: My Recommended Reading, Volatility
    Pivot Intro
    Email from XL - VBA
    Outlook VBA
    Function Dictionary
    Function Translations
    Dynamic Named Ranges
    How to create Excel Dashboards 
    Excel Dashboard / Scorecard Ebook
    Mike Alexander from Data Pig Technologies
    Excel 2007 Dashboards & Reports For Dummies
    Date & Time stamping:
    Get Formula / Formats thru custom functions:
    A nice informative MS article "Improving Performance in Excel 2007"
    Progress Meters
    And, as your skills increase, try answering posts on sites like:
    Michael M
    The more I learn, the less I seem to know.....A Please and Thank You cost nothing !
    It's easier to debug if we can see the whole macro !
    Home 2007 & 2013

    - Posting guidelines, forum rules and terms of use

    - To download Mr Excel HTML Maker

    - Try searching for your answer first, see how

    - Read the FAQs

    - List of BB codes

    [CODE]Place Your Code Here[/CODE]

  5. #5
    New Member
    Join Date
    Nov 2012

    Default Re: Learn VBA

    Thank you guys, for the replies and i will follow what you are saying and will keep posting my doubt on this thread.

    Thanks & regards,
    Rahul Agarwal

  6. #6
    Board Regular strive4peace's Avatar
    Join Date
    Jul 2009

    Default Re: Learn VBA

    here is another link for you (it is free):

    Learn VBA By Crystal
    Warm Regards,
    Microsoft MVP, Access

    Remote Programming and Training ~ let's connect!

    2015 Microsoft MVP Virtual Conference for Access on Channel 9 (MSDN)

    Access Basics
    free book

    have an awesome day

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