+ Reply to Thread
Page 1 of 12 1 2 3 11 ... LastLast
Results 1 to 15 of 166

New to Excel Programming and looking for learning materials

  1. #1
    Registered User
    Join Date
    04-07-2012
    Location
    Enugu,Nigeria
    MS-Off Ver
    Excel 2003
    Posts
    1

    New to Excel Programming and looking for learning materials

    Hello

    Please I am new to excel programming and would like to get started.

    Can anyone help me with basic study materials for a beginner.

  2. #2
    Forum Expert
    Join Date
    10-10-2008
    Location
    Northeast Pennsylvania, USA
    MS-Off Ver
    Excel 2007
    Posts
    2,291

    re: New to Excel Programming and looking for learning materials

    joyofmanygenerations,

    Welcome to the Excel Forum.


    Training / Books / Sites as of 04/05/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

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

    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

    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.contextures.com/excel-dashboards.html
    http://chandoo.org/wp/excel-dashboards/
    http://chandoo.org/wp/management-dashboards-excel/
    http://www.exceldashboardwidgets.com/

    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
    Have a great day,
    Stan

    Windows 10, Excel 2007, on a PC.

    If you are satisfied with the solution(s) provided, please mark your thread as Solved by clicking EDIT in your original post, click GO ADVANCED and set the PREFIX box to SOLVED.

  3. #3
    Registered User
    Join Date
    09-14-2008
    Location
    Chester, IL
    Posts
    7

    re: New to Excel Programming and looking for learning materials

    I've typed this so many times, I'd make it a signature if it wasn't so long, lol...anyhow, here goes.

    -Start with the recorder. It's not very efficient, but it does work. Record yourself doing something...anything...or MANY things (but make a list before you start..you'll see why in a minute), then go into the VBE (ALT+F11) and see what it recorded. That's the syntax for every move you made...literally.

    -Now start to clean it up.
    .....A - If you see anything regarding scrolling...get rid of it.
    .....B - If you see something like:

    Please Login or Register  to view this content.
    that can all be combined to:

    Please Login or Register  to view this content.
    or even just

    Please Login or Register  to view this content.
    get it as 'clean' as you can, then run it and see if it does everything on your list.

    - Surf the forums as often as you can. Look at what people are asking about, then look at the answers given. Create a workbook that represents the question (as best you can), then use the answer given and see what it does. Try different answers for the same question...two routines that look different from each other can do the exact same thing.

    - Get in the habit early on of declaring your variables. You can force this by typing "Option Explicit" at the top of a module, or there is a setting in options in the VBE. Even with the declarations, resist the urge to use Variant for everything ....it will work, but it's not good practice. If you're going to do that, there's no need to declare them at all. Try to type it down as "tight" as you can...for instance, if you're using the variable "i" in a loop and you only want it to loop 10 times ("For i = 1 To 10"), there is no reason to Type "i" as a Long data type, when a Byte data type will be sufficient.

    - Coworkers may have projects for you (ask the boss, lol...or don't blame me if you get caught doing, what they might consider, "screwing around"). Family members. Have you ever ran a business? Could some of the paperwork, etc have been automated? Do that...doesn't matter if it's useful to you, or even to anyone...you're learning.

    - Learn how to use loops, select case statements, if statements, etc. Even if it doesn't do anything but put numbers down a column(with a loop)...try it...try different ways.


    Now that I've said all that, I'll say this:

    There are books out there, but I can't personally comment on any of them, because I've never read any of them. I suspect they are full of syntax and examples that are probably not useful in the real world, lol...but I don't know.
    Last edited by jproffer; 04-08-2012 at 11:25 AM.

  4. #4
    Forum Expert
    Join Date
    10-10-2008
    Location
    Northeast Pennsylvania, USA
    MS-Off Ver
    Excel 2007
    Posts
    2,291

    Re: New to Excel Programming and looking for learning materials

    Leith Ross,

    Comment: A most impressive list of materials and resources. Thanks for sharing that.
    Thank you very much for your comment.

  5. #5
    Forum Contributor
    Join Date
    06-16-2011
    Location
    London
    MS-Off Ver
    Excel XP
    Posts
    277

    Re: New to Excel Programming and looking for learning materials

    I think this thread should be stickied.

  6. #6
    Valued Forum Contributor StevenM's Avatar
    Join Date
    03-23-2008
    Location
    New Lenox, IL USA
    MS-Off Ver
    2007
    Posts
    910

    Re: New to Excel Programming and looking for learning materials

    As a beginner I found the following most helpful:

    (1) "VB & VBA in a Nutshell" by Paul Lomax.

    (2) "VBA and Macros for Microsoft Office Excel 2007" by Bill Jelen & Tracy Syrstad (it has been updated for Excel 2010)

    (3) "Excel 2007 Power Programming with VBA" by John Walkenbach (I believe that it too has been updated for Excel 2010)

    (4) "Excel 2007 VBA: Programmer's Reference" by John Green, Stephen Bullen, Rob Bovey, Michael Alexander (I don't know if it has been updated to 2010)

    As for:

    "Writting Excel Macros with VBA" (2nd edition) by Steven Roman: It is outdated, but I've found it helpful at times. And unfortunately, one mistake in its code took me hours to figure out. It needs to be updated and improved.

    "Mastering Microsoft VBA 2nd Edition" by Guy Hart-Davis is another pre-2007 book, but well-written in my opinion.

  7. #7
    Forum Contributor
    Join Date
    04-06-2006
    Posts
    122

    Re: New to Excel Programming and looking for learning materials

    I had a project thrown at me for work a few weeks ago which was way above my head, and I have been trying to each myself VBA since. Learned a lot in the last three weeks, and the project is finally almost done!!

    What I found the most useful was a step-by-step approach. I picked up Microsoft Excel VBA Programming for Dummies by John Walkenbach and attempted to read it cover to cover. Once it was past the basics, this became more confusing than helpful as I had no relevant referance for the information it was giving. So my approach became this:

    1. Attempt to write the code you need and use the debugger to find where it is messing up
    2. Looked for specifically what I was trying to do in the book - sometimes it was there, sometimes not
    3. Browse these forums and Google the crap out of it. In particular, I try to find code samples doing something simliar to what I am looking for that I can just "tweek" to my needs
    4. And when all else failed, I posted the question here and waited patiently for the experts to show me how, or show me where I went wrong

    It has been a great learning experience, and I really am quite proud of my (almost) final product. But the biggest thing I learned is that you best friend when you are trying to learn this is to just sit down at your keyboard and screw around. Keep hacking away at it until you have it figured it out - a "Learn By Doing" approach.

    Just my two cents worth, but hopefully that is helpful to anyone in my shoes!


  8. #8
    Registered User
    Join Date
    03-25-2012
    Location
    New Jersey
    MS-Off Ver
    Excel 2013
    Posts
    60

    Re: New to Excel Programming and looking for learning materials

    On youtube there are classes called Excel Magic Tricks. There are over 1,000 classes and I found them very helpful. I am a newbie with Excel myself...

  9. #9
    Forum Contributor
    Join Date
    12-14-2007
    Location
    Cork, Ireland
    MS-Off Ver
    excel 2016 64bit
    Posts
    827

    Re: New to Excel Programming and looking for learning materials

    Quote Originally Posted by nevi View Post
    I had a project thrown at me for work a few weeks ago which was way above my head, and I have been trying to each myself VBA since. Learned a lot in the last three weeks, and the project is finally almost done!!

    What I found the most useful was a step-by-step approach. I picked up Microsoft Excel VBA Programming for Dummies by John Walkenbach and attempted to read it cover to cover. Once it was past the basics, this became more confusing than helpful as I had no relevant referance for the information it was giving. So my approach became this:

    1. Attempt to write the code you need and use the debugger to find where it is messing up
    2. Looked for specifically what I was trying to do in the book - sometimes it was there, sometimes not
    3. Browse these forums and Google the crap out of it. In particular, I try to find code samples doing something simliar to what I am looking for that I can just "tweek" to my needs
    4. And when all else failed, I posted the question here and waited patiently for the experts to show me how, or show me where I went wrong

    It has been a great learning experience, and I really am quite proud of my (almost) final product. But the biggest thing I learned is that you best friend when you are trying to learn this is to just sit down at your keyboard and screw around. Keep hacking away at it until you have it figured it out - a "Learn By Doing" approach.

    Just my two cents worth, but hopefully that is helpful to anyone in my shoes!

    this has been my approach over the last 6 years, unfortunately the projects arise about once a year and I forget what progess I have made
    I've been intrigued with functions/vba since i noticed conditional formatting on a worksheet. Shame this stuff was not around when I started... getting there slowly though

  10. #10
    Registered User
    Join Date
    07-20-2012
    Location
    dg
    MS-Off Ver
    Excel 2003
    Posts
    2

    Re: New to Excel Programming and looking for learning materials

    Hello:
    I need help and sorry if you misunderstood.

    I have excel sheet which i have attached (upated version) which generates a paid receipt.
    To get the receipt, i go to Receipt sheet and enter the Receipt # in cell P1 to P2 (Receipt # is chosen from "Donation" sheet.
    Once Receipt# is entered, the other information is populated and now i need this to be printed as Receipt as pdf file.
    So basically, i would have 1 pdf file for each donation receipt.

    The name of the pdf file would need be created by the values in certain cell.
    (Remember that values in cell are populated from other part of the worksheet)


    ---------------------


    Les Lunettes De Soleil

  11. #11
    Forum Moderator jeffreybrown's Avatar
    Join Date
    02-19-2009
    Location
    Cibolo, TX
    MS-Off Ver
    Excel 2007
    Posts
    7,539

    Re: New to Excel Programming and looking for learning materials

    Hello gkutt & Welcome to the Forum, unfortunately:

    Your post does not comply with Rule 2 of our Forum RULES. Don't post a question in the thread of another member -- start your own thread. If you feel it's particularly relevant, provide a link to the other thread. It makes sense to have a new thread for your question because a thread with numerous replies can be off putting & difficult to pick out relevant replies.
    HTH
    Regards, Jeff

  12. #12
    Registered User
    Join Date
    01-11-2010
    Location
    Sheffield
    MS-Off Ver
    Excel 2003
    Posts
    8

    Re: New to Excel Programming and looking for learning materials

    I have a spreasheet which calculates something. I need to run data through the calculations and record the results. I have over a hundred sets of data and was wondering if a macro can be used to repeat the calculation.

    At the moment in Sheet1 all the data sets have their own row with all the data to be used in the calculation, in Sheet2 is my calculation is based on info from the set of data.

    I would like my results to be on Sheet1 on the same row after all the data.

    Can anyboby help?

  13. #13
    Forum Moderator jeffreybrown's Avatar
    Join Date
    02-19-2009
    Location
    Cibolo, TX
    MS-Off Ver
    Excel 2007
    Posts
    7,539

    Re: New to Excel Programming and looking for learning materials

    Hi fozzy9222, unfortunately:

    Your post does not comply with Rule 2 of our Forum RULES. Don't post a question in the thread of another member -- start your own thread. If you feel it's particularly relevant, provide a link to the other thread. It makes sense to have a new thread for your question because a thread with numerous replies can be off putting & difficult to pick out relevant replies.

  14. #14
    Registered User
    Join Date
    08-19-2012
    Location
    Cambodia
    MS-Off Ver
    Excel 2007
    Posts
    10

    Re: New to Excel Programming and looking for learning materials

    There are a lot of Excel VBA materials to learn here:http://www.worldbestlearningcenter.c...erstanding.htm

  15. #15
    Registered User
    Join Date
    08-21-2012
    Location
    New York
    MS-Off Ver
    Excel 2007
    Posts
    1

    Re: New to Excel Programming and looking for learning materials

    There is a complete Excel/VBA Sudoku Puzzle Teacher program with about 3000 lines of VBA code available at Sudoku Teacher Sudoku Helper if you are looking to get started with excel/VBA programming. ScreenShot.jpg

+ Reply to Thread
Page 1 of 12 1 2 3 11 ... LastLast

Thread Information

Users Browsing this Thread

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

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1