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
    Posts
    3

    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
    VoG is offline
    MrExcel MVP
    Moderator
    VoG's Avatar
    Join Date
    Jun 2002
    Location
    127.0.0.1
    Posts
    63,440
    HTH, Peter
    Please test any code on a copy of your workbook.

  3. #3
    MrExcel MVP
    Moderator
    Smitty's Avatar
    Join Date
    May 2003
    Location
    Crested Butte, CO
    Posts
    27,238

    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.

    HTH,
    Smitty

    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
    Location
    Western NSW
    Posts
    10,083

    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
    Code:
    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.
    http://www.mrexcel.com/forum/forumdisplay.php?f=19
    
    There are over 1800 Excel videos/tutorials here:
    http://www.youtube.com/user/ExcelIsFun
    
    Getting Started with VBA. 
    http://www.datapigtechnologies.com/ExcelMain.htm
    
    If you are serious about learning VBA try 
    http://www.add-ins.com/vbhelp.htm
    
    Excel Tutorials and Tips - VBA - macros - training
    http://www.mrexcel.com/articles.shtml
    
    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
    http://www.mvps.org/dmcritchie/excel/getstarted.htm
    
    What is a Visual Basic Module?
    http://www.emagenit.com/VBA%20Folder...vba_module.htm
    
    Ron de Bruin's intro to macros:
    http://www.rondebruin.nl/code.htm
    
    Creating An XLA Add-In For Excel, Writing User Defined Functions In VBA
    http://www.cpearson.com/excel/createaddin.aspx
    
    How do I create a PERSONAL.XLS(B) or Add-in
    http://www.rondebruin.nl/personal.htm
    
    Creating custom functions
    http://office.microsoft.com/en-us/ex...117011033.aspx
    
    Writing Your First VBA Function in Excel
    http://www.exceltip.com/st/Writing_Y...Excel/631.html
    
    VBA for Excel (Macros)
    http://www.excel-vba.com/excel-vba-contents.htm
    
    VBA Lesson 11: VBA Code General Tips and General Vocabulary
    http://www.excel-vba.com/vba-code-2-1-tips.htm
    
    Excel VBA -- Adding Code to a Workbook
    http://www.contextures.com/xlvba01.html
    
    Learn to debug: 
    http://www.cpearson.com/excel/debug.htm
    
    How To: Assign a Macro to a Button or Shape
    http://peltiertech.com/WordPress/how...tton-or-shape/
    
    User Form Creation
    http://www.contextures.com/xlUserForm01.html
    
    When To Use a UserForm & What to Use a UserForm For
    http://www.ozgrid.com/Excel/free-tra...ba2lesson2.htm
    
    Excel Tutorials / Video Tutorials - Functions
    http://www.contextures.com/xlFunctions02.html
    
    INDEX MATCH - Excel Index Function and Excel Match Function
    http://www.contextures.com/xlFunctions03.html
    
    Excel Data Validation
    http://www.contextures.com/xlDataVal08.html#Larger
    http://www.contextures.com/excel-dat...ation-add.html
    
    Your Quick Reference to Microsoft Excel Solutions
    http://www.xl-central.com/index.html
    
    New! Excel Recorded Webinars
    http://www.datapigtechnologies.com/ExcelMain.htm
    
    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.
    http://www.cpearson.com/Excel/vbe.aspx
    
    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
    http://www.decisionmodels.com/calcsecretsi.htm
    
    Sumproduct
    http://www.xldynamic.com/source/xld.SUMPRODUCT.html
    
    Arrays
    http://www.xtremevbtalk.com/showthread.php?t=296012
    http://www.vbtutor.net/vba/vba_chp21.htm
    
    Pivot Intro
    http://peltiertech.com/Excel/Pivots/pivotstart.htm
    
    Email from XL - VBA
    http://www.rondebruin.nl/sendmail.htm
    
    Outlook VBA
    http://www.outlookcode.com/article.aspx?ID=40
    
    Function Dictionary
    http://www.xlfdic.com/
    
    Function Translations
    http://www.piuha.fi/excel-function-name-translation/
    
    Dynamic Named Ranges
    http://www.contextures.com/xlNames01.html
    
    How to create Excel Dashboards
    http://www.mrexcel.com/Excel-dashboards-Xcelsius.html
    http://www.contextures.com/excel-dashboards.html
    http://chandoo.org/wp/excel-dashboards/
    http://chandoo.org/wp/management-dashboards-excel/
    http://www.exceldashboardwidgets.com/
    http://www.andypope.info/charts/gauge.htm 
    
    Excel Dashboard / Scorecard Ebook
    http://www.qimacros.com/excel-dashboard-scorecard.html
    
    Mike Alexander from Data Pig Technologies
    Excel 2007 Dashboards & Reports For Dummies
    
    Templates
    http://www.cpearson.com/Excel/Topic.aspx
    http://www.contextures.com/excel-tem...lf-scores.html
    
    Date & Time stamping:
    http://www.mcgimpsey.com/excel/timestamp.html
    
    Get Formula / Formats thru custom functions:
    http://dmcritchie.mvps.org/excel/formula.htm#GetFormat
    
    A nice informative MS article "Improving Performance in Excel 2007"
    http://msdn.microsoft.com/en-us/library/aa730921.aspx
    
    Progress Meters
    http://www.andypope.info/vba/pmeter.htm
    http://www.xcelfiles.com/ProgressBar.html
    
    And, as your skills increase, try answering posts on sites like:
    http://www.mrexcel.com
    http://www.excelforum.com
    http://www.ozgrid.com
    http://www.vbaexpress.com
    http://www.excelfox.com
    Regards
    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 !
    work 2003, Home 2007

    - 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
    Posts
    3

    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
    Location
    Colorado
    Posts
    546

    Default Re: Learn VBA

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

    Learn VBA By Crystal
    Warm Regards,
    Crystal
    Microsoft MVP, Access

    Remote Programming and Training ~ let's connect!
    http://msaccessgurus.com/

    Code Documenter for Access, Excel, Word, and PowerPoint
    http://www.AccessMVP.com/strive4peac...Documenter.htm


    Learn Access By Crystal video playlist
    http://www.youtube.com/playlist?p=PL1B2705CCB40CA4CA

    Access Basics
    http://www.accessmvp.com/strive4peace
    free book

    Access Contact Template
    http://www.youtube.com/watch?v=wVYnIM2oYkg


    *
    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
  •  


DMCA.com