+ Reply to Thread
Results 1 to 29 of 29

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.

    Mod Edit (10 August 2018):

    PLEASE NOTE:

    This thread is a sticky as it has become a compendium of useful links and resources for members to use to learn VBA.

    You may post to this thread ONLY if you have a new resource to add to the list (this must NOT include advertising links - see our forum's rules).

    If you wish to thank anyone who has contributed to this thread, please do so using the reputation system by clicking on the star to the bottom left of one of their posts and leaving a 'thank you' message. Any 'thank yous' or other 'noise' posted to this thread should be reported and will be deleted. This is so that the thread remains clean and easy to navigate for all.

    Thank you all for your co-operation.
    Last edited by AliGW; 08-10-2018 at 04:11 AM.

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

    re: New to Excel Programming and looking for learning materials

    Latest update from Stan (thanks Stan)
    See if something, in the below link(s), of my most up to date list will help you:
    Training / Books / Sites as of 2/3/2018

    What Is VBA?
    https://www.techwalla.com/articles/what-is-vba

    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
    http://www.mrexcel.com/store/index.p...t_detail&p=306

    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

    MrExcel's Excel Tutorial Listing
    http://www.mrexcel.com/articles.shtml

    [VBA] Difference between OLEFormat and ControlFormat?
    For references purposes and excellent explanations, see
    http://wellsr.com/vba/excel/#guides

    Excel VBA MACRO Kick-start Course for absolute beginner

    Free VBA Course
    http://www.excel-pratique.com/en/vba.php

    Excel 2007 VBA materials to learn here:
    http://www.worldbestlearningcenter.c...erstanding.htm

    The macro recorder actually is your friend but look here:
    http://www.tushar-mehta.com/excel/vb...acro_recorder/

    Introduction to Variables, Constants and Data Types
    http://msdn.microsoft.com/en-us/libr...(v=vs.60).aspx

    Declaring Variables
    http://www.cpearson.com/excel/declaringvariables.aspx

    Here's a good primer on the scope of variables.
    http://www.cpearson.com/excel/scope.aspx
    Variable Scope in Excel VBA - EASY Excel Macros
    Understanding Scope

    Using Variables in Excel VBA Macro Code
    http://www.ozgrid.com/VBA/variables.htm

    See David McRitchie's site if you just started with VBA
    http://www.mvps.org/dmcritchie/excel/getstarted.htm

    What is a VBA Module and How is a VBA Module Used?
    http://www.emagenit.com/VBA%20Folder...vba_module.htm

    Events And Event Procedures In VBA
    http://www.cpearson.com/excel/Events.aspx

    Here is a good introductory tutorial using a VBA Class:
    http://www.cpearson.com/excel/classes.aspx

    There's a chapter on classes in VBA Developer's Handbook which is also good.
    http://www.amazon.com/VBA-Developers.../dp/0782129781

    Ron's Excel Tips
    http://www.rondebruin.nl/tips.htm

    Ron de Bruin's Mail from Excel and make/mail PDF files (Windows)
    http://www.rondebruin.nl/win/section1.htm

    How do I create and use a PERSONAL file for my VBA code
    http://www.rondebruin.nl/win/personal.htm

    Anthony's Excel VBA Page - Excel Application - Excel Consultant - Excel Consulting (see 3 tutorials in Excel VBA Basic Tutorial Series)

    BET: Microsoft Excel Visual Basic

    Debugging VBA
    http://www.cpearson.com/Excel/DebuggingVBA.aspx

    Debug Excel VBA Macro Code
    http://www.ozgrid.com/VBA/debug.htm

    TechBookReport - Debugging Excel VBA Code
    http://www.techbookreport.com/tutori...el_vba_01.html

    Here are some general links on performance improvement:
    https://www.soa.org/News-and-Publica...s42-roper.aspx
    Optimize Slow VBA Code. Speed Up Efficient VBA Code/Macros
    Excel VBA Performance Coding Best Practices - Office Blogs
    https://msdn.microsoft.com/en-us/library/aa730921.aspx

    Start at the beginning...

    Creating An XLA Add-In For Excel, Writing User Defined Functions In VBA
    http://www.cpearson.com/excel/createaddin.aspx

    Build an Excel Add-In
    http://www.fontstuff.com/vba/vbatut03.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

    Excel Macros Tutorial
    http://www.excel-vba.com/excel-vba-contents.htm

    Excel Macros & Programming
    http://www.excel-vba.com/index.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

    Beyond Excel's recorder

    Helpful as a simple concise reference for the basics, and, using the macro recorder is endlessly powerful.
    http://www.techonthenet.com/excel/cells/index.php

    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

    Build a UserForm for Excel
    http://www.fontstuff.com/ebooks/free/fsuserforms.pdf

    When To Use a UserForm & What to Use a UserForm For
    http://www.ozgrid.com/Excel/free-tra...ba2lesson2.htm

    UserForms in Excel VBA - UserForm Basics; Add Controls dynamically at run-time using the Add Method; UserForm Controls (A Snapshot)

    VBA add UserForm on the fly
    http://www.vbaexpress.com/kb/getarticle.php?kb_id=228

    Excel VBA how to Personalise the Ribbon
    http://www.bing.com/videos/search?q=...bbon&FORM=VDRE

    Excel Tutorials / Video Tutorials - Functions
    http://www.contextures.com/xlFunctions02.html

    How to insert Buttons, radio buttons and check boxes in Excel
    http://www.bing.com/videos/search?q=...xcel&FORM=VDRE

    INDEX MATCH - Excel Index Function and Excel Match Function
    http://www.contextures.com/xlFunctions03.html

    Multi or two way vlook up and index match tutorial
    http://www.get-digital-help.com/

    Excel Data Validation
    http://www.contextures.com/xlDataVal08.html#Larger
    http://www.contextures.com/excel-dat...ation-add.html

    Excel -- Data Validation -- Create Dependent Lists
    http://www.contextures.com/xlDataVal02.html

    http://www.get-digital-help.com/2010...lues-in-excel/

    Your Quick Reference to Microsoft Excel Solutions
    http://www.xl-central.com/index.html

    New! Excel Recorded Webinars
    http://www.datapigtechnologies.com/ExcelMain.htm

    MS Excel: VBA Functions - Listed by Category
    MS Excel: ALL Formulas/Functions - Listed by Category

    Fuzzy Matching - new version plus explanation
    http://www.mrexcel.com/forum/excel-q...planation.html

    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

    John Walkenbach's power programming with Excel books.

    Excel 2010 Power Programming with VBA, Mr. Spreadsheet's Bookshelf

    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

    Professional Excel Development by Rob Bovey, Dennis Wallentin, Stephen Bullen, & John Green

    DonkeyOte: My Recommended Reading, Volatility
    http://www.decisionmodels.com/calcsecretsi.htm

    A list of Reference Books
    http://www.andypope.info/books/books.htm

    Sumproduct
    http://www.xldynamic.com/source/xld.SUMPRODUCT.html

    Need to understand error handling
    http://www.cpearson.com/excel/errorhandling.htm

    Excel file error message
    How to diagnose Excel file corruption and repair workbooks

    If a file cannot be repaired, consider recovering an earlier version from your file history
    https://support.microsoft.com/en-us/...8-file-history

    Arrays
    http://www.mrexcel.com/forum/showthread.php?t=390246
    http://www.cpearson.com/excel/VBAArrays.htm
    http://www.xtremevbtalk.com/showthread.php?t=296012
    http://www.vbtutor.net/vba/vba_chp21.htm
    http://excelmacromastery.com/Blog/in...-in-excel-vba/
    Last edited by FDibbins; 08-09-2018 at 06:23 PM.
    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
    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.

  5. #5
    Forum Contributor
    Join Date
    04-06-2006
    Posts
    131

    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!


  6. #6
    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

  7. #7
    Forum Contributor
    Join Date
    08-22-2012
    Location
    nj, us
    MS-Off Ver
    Excel 2010
    Posts
    163

    Re: New to Excel Programming and looking for learning materials


  8. #8
    Registered User
    Join Date
    01-01-2010
    Location
    The Netherlands
    MS-Off Ver
    Office 2003
    Posts
    27

    Re: New to Excel Programming and looking for learning materials

    Very useful for me as a beginner was:
    http://www.angelfire.com/biz7/julian...ans_macros.htm

  9. #9
    Registered User
    Join Date
    12-04-2012
    Location
    Orange, Australia
    MS-Off Ver
    Excel 2007
    Posts
    8

    Re: New to Excel Programming and looking for learning materials

    Wow - this demonstrates the absolute value of this forum. Well done all.

    I've agree that this page needs to be stickied (what ever that is).

    I've found http://www.techonthenet.com/ to be very helpful as a simple concise reference for the basics.
    And using the macro recorder is endlessly powerful although you do need to understand the limitations of cutting and pasting from the recorded code.

    Some other basic tips:
    • Always always use "Options Explicit".
    • When working with multiple work sheets I like to create "WorkSheet" variables to represent worksheets and define them using "set wsControl = Sheets("Control"). You can then better use the autocomplete capabilities of the Macro editor.
    • When working with data that is ever likely to change in structure, rather than hard coding rows and columns, used named references to define key rows/columns and then use the wsData.Range("<Defined Name>") to get the correct row/column you need. Then if you add a row a column, your code keeps working.
    • Use comments. Comment and comment some more. Some say there should be more comments than code. Unless you're supremely good at naming variables (the hardest part of coding) then you'll forget how your code works in a couple of months and others will have even less chance.
    • Learn some basics of the debugger. How to put in a break point. How to add a watch. F8 - step line by line, F5 - run to next breakpoint.

    Hope that helps.
    Last edited by apembo; 12-07-2012 at 05:45 PM.

  10. #10
    Registered User
    Join Date
    01-23-2013
    Location
    United States
    MS-Off Ver
    Excel 2007
    Posts
    5

    Re: New to Excel Programming and looking for learning materials

    I am also fairly new to VBA programming. I recently purchased "VBA and Macros for Microsoft Office Excel 2007" by Bill Jelen & Tracy Syrstad (it has been updated for Excel 2010) and "Excel 2010 Power Programming with VBA" by John Walkenbach. Both are very well written and easy to understand. Good luck and Have fun!!

  11. #11
    Forum Guru xladept's Avatar
    Join Date
    04-14-2012
    Location
    Pasadena, California
    MS-Off Ver
    Excel 2003,2010
    Posts
    12,372

    Re: New to Excel Programming and looking for learning materials

    I think that "Writing Excel Macros" by Steven Roman and published by O'Reilly has been cited above, but it's the book that I learned from and still refer to when concepts get dicey.
    If I've helped you, please consider adding to my reputation - just click on the liitle star at the left.

    ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~(Pride has no aftertaste.)

    You can't do one thing. XLAdept

    ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~aka Orrin

  12. #12
    Registered User
    Join Date
    04-04-2013
    Location
    Here
    MS-Off Ver
    Excel 2010/2013
    Posts
    8

    Re: New to Excel Programming and looking for learning materials

    Hello,

    I created a VBA course (complete and 100% free) to learn VBA from 0.

    11 lessons :

    1. Introduction
    2. Sheets and cells
    3. Variables
    4. Conditions
    5. Loops
    6. Procedures and functions
    7. Dialog boxes
    8. Events
    9. Forms and controls
    10. Arrays
    11. Supplements


    http://www.excel-pratique.com/en/vba.php

    Can you add this link to the list?

    V-B-A

  13. #13
    Registered User
    Join Date
    05-23-2013
    Location
    ggn
    MS-Off Ver
    Excel 2007
    Posts
    1

    Re: New to Excel Programming and looking for learning materials

    Another good tutorial to learn basics of vba.
    https://www.youtube.com/watch?v=e1NOdjRkLIY

  14. #14
    Registered User
    Join Date
    05-01-2008
    Posts
    17

    Re: New to Excel Programming and looking for learning materials

    Consider "Excel Programming Weekend Crash Course by Peter G. Aitken." It isn't exhaustive, but what is covered is explained very clearly with a minimum of jargon. Good luck!

  15. #15
    Registered User
    Join Date
    11-29-2013
    Location
    Townsville, Australia
    MS-Off Ver
    Excel 2010
    Posts
    23

    Re: New to Excel Programming and looking for learning materials

    You should also have a look at

    http://msdn.microsoft.com/en-us/libr...ice.11%29.aspx

    which is a MS VBA reference library. Most useful.

    OM1950

  16. #16
    Registered User
    Join Date
    03-14-2014
    Location
    USA
    MS-Off Ver
    Excel 2010
    Posts
    3

    Re: New to Excel Programming and looking for learning materials

    I found some of these links that were helpful to get started. Some of them are from universities:

    http://www.chem.mtu.edu/~fmorriso/cm...rial1_2010.pdf

    http://www.faculty.virginia.edu/riba.../VBAPrimer.pdf

    These other ones have pretty easy to understand tutorials for absolute beginners like me:

    http://www.softwaretrainingtutorials...asic-excel.php

    http://www.vbaexceltutorial.com/

    Hope this helps!

  17. #17
    Registered User
    Join Date
    06-03-2009
    Location
    Florida
    MS-Off Ver
    Excel 2007 / Excel 2010
    Posts
    89

    Re: New to Excel Programming and looking for learning materials

    Just adding 2 resources I've been using that have been helping me a lot.

    Udemy - Infinite Skills - Microsoft VBA Excel Tutorial
    Excel VBA and Macros 2010 by Bill Jelen

    Udemy course is great for beginners, and the Bill Jelen book is more advanced for a beginner. But been learning quite a bit using them together.

    Good luck fellow coders

  18. #18
    Forum Contributor
    Join Date
    03-12-2014
    Location
    Asheville, NC
    MS-Off Ver
    Excel 2016
    Posts
    99

    Re: New to Excel Programming and looking for learning materials

    I recently stumbled across a tutorial channel on YouTube called "Wise Owl Tutorials". I started about 2 weeks ago, and have now built a multi-page program that is functional. He is REALLY good at taking small steps and explaining thoroughly. Here is the link:

    https://www.youtube.com/playlist?lis...3akx_gFMnpxTN5

    Enjoy!

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

    Re: New to Excel Programming and looking for learning materials

    pulsar777,

    See if the following links will help you:

    Here is a good introductory tutorial using a VBA Class:
    http://www.cpearson.com/excel/classes.aspx

    There's a chapter on classes in VBA Developer's Handbook which is also good.
    http://www.amazon.com/VBA-Developers.../dp/0782129781

  20. #20
    Registered User
    Join Date
    01-17-2017
    Location
    Germany
    MS-Off Ver
    Excel 2016
    Posts
    2

    Re: New to Excel Programming and looking for learning materials

    Hi, I would like to suggest Excel Dashboard School for free dashboard training materials.

  21. #21
    Forum Contributor sorensjp's Avatar
    Join Date
    12-23-2015
    Location
    Yokosuka, JP
    MS-Off Ver
    2007 and 2016
    Posts
    134

    Re: New to Excel Programming and looking for learning materials

    Hello,

    I've learned a lot and used a great many templates from Trevor Easton's site Onlinepclearning and YouTube Channel.
    Site:
    http://www.onlinepclearning.com/
    YouTube Channel:
    https://www.youtube.com/user/OnLinePCLearning/featured

    He has many templates VBA and Non-VBA projects ready for download and you create and change to suit your needs. Very well laid out and explained for each project in an accompanying YouTube video.

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

    Re: New to Excel Programming and looking for learning materials

    Progress Meters
    http://www.andypope.info/vba/pmeter.htm
    http://www.xcelfiles.com/ProgressBar.html

    How to convert text to numbers in Excel
    http://support.microsoft.com/kb/291047

    How to parse data from the web - Brett Fret has a video in YouTube
    http://www.youtube.com/watch?v=6H7tBL97orE

    Excel VBA MAC shortcuts
    http://www.mrexcel.com/forum/excel-q...uts-excel.html

    http://www.internet4classrooms.com/e...yboard_mac.htm
    http://office.microsoft.com/en-us/ma...102927337.aspx

    http://office.microsoft.com/en-us/ex...010073848.aspx

    Excel VLOOKUP Multiple Sheets • My Online Training Hub

    Wise Owl Tutorials
    https://www.youtube.com/playlist?lis...3akx_gFMnpxTN5
    https://www.youtube.com/watch?v=KHO5...3akx_gFMnpxTN5

    http://msdn.microsoft.com/en-us/library/cc837974.aspx
    Merging Data from Multiple Workbooks into a Summary Workbook in Excel
    Merge data from all workbooks in a folder
    Merging a Range from Selected Workbooks
    Merging a Range from Multiple Workbooks by Column
    Merging a Range from Multiple Workbooks in a Folder with a Filter

    Filtering Horizontally, or both
    https://www.mrexcel.com/forum/excel-...izontally.html
    https://www.mrexcel.com/forum/excel-...ng-macros.html
    http://blog.livedoor.jp/andrewe/archives/50283818.html
    https://stackoverflow.com/questions/...d-horizontally
    https://chandoo.org/forum/threads/fi...tically.14283/

    You could do a Google search with “You Tube” and use the foollowing names, and/or, links:
    https://www.youtube.com/playlist?lis...3akx_gFMnpxTN5
    https://www.youtube.com/watch?v=ABXP...S5k4zsvnu2mkJC
    https://www.youtube.com/watch?v=KHO5...3akx_gFMnpxTN5
    https://www.youtube.com/watch?v=kd6Z...VH5Dq42RG9tlRP
    https://www.youtube.com/watch?v=AIhK...suD6oNDaOk3vbR
    https://www.youtube.com/watch?v=Z08z...Z_6brD5Gk1sVy_
    https://www.youtube.com/user/ExcelVbaIsFun/playlists
    https://www.youtube.com/watch?v=o_d8...lhXL_9m7EAgcMq
    https://www.youtube.com/user/ExcelVB...ort=dd&view=50
    https://www.youtube.com/playlist?lis...o2SEPBLLPGOyBz
    https://www.youtube.com/watch?v=y_1e...7lleNVtNeAhBVC
    https://www.youtube.com/watch?v=CDYk...007E847B3E6658
    https://www.youtube.com/user/ExcelVbaIsFun/videos

    Some other Threads where VBA learning was discussed:
    Basics of Excel VBA and Code writting
    Excel VBA
    http://www.excelforum.com/excel-form...ml#post4250487
    http://www.excelforum.com/excel-gene...s-for-vba.html
    https://members.excelcampus.com/a/1523/fdzAdugs

    Sending mail from Excel with CDO
    http://www.rondebruin.nl/win/s1/cdo.htm

    And, as your skills increase, try answering threads on sites like:
    http://www.mrexcel.com
    http://www.excelforum.com
    http://www.ozgrid.com
    http://www.vbaexpress.com
    http://www.excelfox.com

    If you are willing to spend money for the training, then something here should work for you...
    http://www.amazon.com/s/?ie=UTF8&key...l_5givffg47i_b

    Advanced Excel Training - Online Excel Course
    http://www.udemy.com/advanced-excel/

    Learn VBA Fast, Vol. I: Excel function design course, with practice exercises (The VBA Function Design Course Book 1)
    http://www.amazon.co.uk/dp/B00M6E8MBW

    Excel VBA Programmer Interview - Excel Test for interview
    http://www.vbaexpress.com/forum/show...mer-Interview&

    Excel tests
    http://www.excel-skills.com/demos2010/skills_test.php
    http://www.skills-assessment.net/hom...dex.aspx?e=135
    https://www.wiziq.com/tests/ms-excel

    Here is another Function translator that is extremely popular:
    http://en.excel-translator.de/functions/text/
    It will also translate Formulas as well
    http://en.excel-translator.de/translator/

    Here a couple of good blogs on the R1C1 Style Notation
    https://smurfonspreadsheets.wordpres...r1c1-notation/
    http://powerspreadsheets.com/r1c1-formular1c1-vba/

    Top ten ways to clean your data
    https://support.office.com/en-us/art...f-9cfc08a0a4e3

    Analytical reasoning test of Excel aptitude
    http://www.exceltip.com/wp-content/u...-Questions.pdf

    RegEX question - Alpha only upper case only.
    Regex Tutorialā€”From Regex 101 to Advanced Regex
    Regular Expression Tutorial - Learn How to Use Regular Expressions
    https://www.princeton.edu/~mlovett/r...xpressions.pdf

    The VBA Guide To ListObject Excel Tables
    https://www.thespreadsheetguru.com/b...t-excel-tables

    Hiding Macros
    https://www.mrexcel.com/forum/excel-...ng-macros.html

    Excel keyboard shortcuts
    http://www.asap-utilities.com/excel-tips-shortcuts.php
    A nearly complete Microsoft list, from thisoldman:
    https://support.office.com/en-us/art...9-9b7213f0040f
    This has some that aren't listed on the MS page:
    http://www.asap-utilities.com/excel-tips-shortcuts.php
    And this one:
    https://exceljet.net/keyboard-shortcuts
    Microsoft changed some shortcuts between 2003 and 2007 versions and they continue to change them.
    Menu shortcuts, get changed too.
    If you have a newer version of Excel, type Alt+d and a message will pop up: "Continue typing the menu key sequence ..."
    My favorite little known key sequences are the context menu shortcuts.
    If you're on Windows with a keyboard that has a menu key, copy a range of cells, then select a destination.
    Press the menu key (between Rt-Alt and Rt-Ctrl) then press V to paste values only, or R to paste formats only, or T to transpose+paste.

  23. #23
    Registered User
    Join Date
    04-21-2009
    Location
    Ecuador
    MS-Off Ver
    Excel 2016
    Posts
    9

    Re: New to Excel Programming and looking for learning materials

    Hi,

    If you want to understand the VBA syntax to write your own macros and understand the macros written from others, you should definitely understand the fundamental concept called Excel object model.

    Here are some Excel object model articles that might help:

    https://msdn.microsoft.com/en-us/vba...-vba-reference
    http://www.dummies.com/software/micr...-object-model/
    https://www.wizdoh.com/excel-vba-obj...l-demystified/
    https://powerspreadsheets.com/excel-vba-object-model/

    Thanks
    John Franco
    https://www.excelgurusacademy.com/

  24. #24
    Registered User
    Join Date
    05-07-2012
    Location
    Michigan
    MS-Off Ver
    Microsoft Office 365 ProPlus
    Posts
    44

    Re: New to Excel Programming and looking for learning materials

    Hello,
    I site I used when I started was

    Excel Macro Mastery

    VBA for Beginners.

    Good Luck...

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

    Re: New to Excel Programming and looking for learning materials

    The following update will need to be in the next two replies:

    See if something, in the below link(s), of my most up to date list will help you:
    Training / Books / Sites as of 2/3/2018

    What Is VBA?
    https://www.techwalla.com/articles/what-is-vba

    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
    http://www.mrexcel.com/store/index.p...t_detail&p=306

    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

    MrExcel's Excel Tutorial Listing
    http://www.mrexcel.com/articles.shtml

    [VBA] Difference between OLEFormat and ControlFormat?
    For references purposes and excellent explanations, see
    http://wellsr.com/vba/excel/#guides

    Excel VBA MACRO Kick-start Course for absolute beginner

    Free VBA Course
    http://www.excel-pratique.com/en/vba.php

    Excel 2007 VBA materials to learn here:
    http://www.worldbestlearningcenter.c...erstanding.htm

    The macro recorder actually is your friend but look here:
    http://www.tushar-mehta.com/excel/vb...acro_recorder/

    Introduction to Variables, Constants and Data Types
    http://msdn.microsoft.com/en-us/libr...(v=vs.60).aspx

    Declaring Variables
    http://www.cpearson.com/excel/declaringvariables.aspx

    Here's a good primer on the scope of variables.
    http://www.cpearson.com/excel/scope.aspx
    Variable Scope in Excel VBA - EASY Excel Macros
    Understanding Scope

    Using Variables in Excel VBA Macro Code
    http://www.ozgrid.com/VBA/variables.htm

    See David McRitchie's site if you just started with VBA
    http://www.mvps.org/dmcritchie/excel/getstarted.htm

    What is a VBA Module and How is a VBA Module Used?
    http://www.emagenit.com/VBA%20Folder...vba_module.htm

    Events And Event Procedures In VBA
    http://www.cpearson.com/excel/Events.aspx

    Here is a good introductory tutorial using a VBA Class:
    http://www.cpearson.com/excel/classes.aspx

    There's a chapter on classes in VBA Developer's Handbook which is also good.
    http://www.amazon.com/VBA-Developers.../dp/0782129781

    Ron's Excel Tips
    http://www.rondebruin.nl/tips.htm

    Ron de Bruin's Mail from Excel and make/mail PDF files (Windows)
    http://www.rondebruin.nl/win/section1.htm

    How do I create and use a PERSONAL file for my VBA code
    http://www.rondebruin.nl/win/personal.htm

    Anthony's Excel VBA Page - Excel Application - Excel Consultant - Excel Consulting (see 3 tutorials in Excel VBA Basic Tutorial Series)

    BET: Microsoft Excel Visual Basic

    Debugging VBA
    http://www.cpearson.com/Excel/DebuggingVBA.aspx

    Debug Excel VBA Macro Code
    http://www.ozgrid.com/VBA/debug.htm

    TechBookReport - Debugging Excel VBA Code
    http://www.techbookreport.com/tutori...el_vba_01.html

    Here are some general links on performance improvement:
    https://www.soa.org/News-and-Publica...s42-roper.aspx
    Optimize Slow VBA Code. Speed Up Efficient VBA Code/Macros
    Excel VBA Performance Coding Best Practices - Office Blogs
    https://msdn.microsoft.com/en-us/library/aa730921.aspx

    Start at the beginning...

    Creating An XLA Add-In For Excel, Writing User Defined Functions In VBA
    http://www.cpearson.com/excel/createaddin.aspx

    Build an Excel Add-In
    http://www.fontstuff.com/vba/vbatut03.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

    Excel Macros Tutorial
    http://www.excel-vba.com/excel-vba-contents.htm

    Excel Macros & Programming
    http://www.excel-vba.com/index.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

    Beyond Excel's recorder

    Helpful as a simple concise reference for the basics, and, using the macro recorder is endlessly powerful.
    http://www.techonthenet.com/excel/cells/index.php

    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

    Build a UserForm for Excel
    http://www.fontstuff.com/ebooks/free/fsuserforms.pdf

    When To Use a UserForm & What to Use a UserForm For
    http://www.ozgrid.com/Excel/free-tra...ba2lesson2.htm

    UserForms in Excel VBA - UserForm Basics; Add Controls dynamically at run-time using the Add Method; UserForm Controls (A Snapshot)

    VBA add UserForm on the fly
    http://www.vbaexpress.com/kb/getarticle.php?kb_id=228

    Excel VBA how to Personalise the Ribbon
    http://www.bing.com/videos/search?q=...bbon&FORM=VDRE

    Excel Tutorials / Video Tutorials - Functions
    http://www.contextures.com/xlFunctions02.html

    How to insert Buttons, radio buttons and check boxes in Excel
    http://www.bing.com/videos/search?q=...xcel&FORM=VDRE

    INDEX MATCH - Excel Index Function and Excel Match Function
    http://www.contextures.com/xlFunctions03.html

    Multi or two way vlook up and index match tutorial
    http://www.get-digital-help.com/

    Excel Data Validation
    http://www.contextures.com/xlDataVal08.html#Larger
    http://www.contextures.com/excel-dat...ation-add.html

    Excel -- Data Validation -- Create Dependent Lists
    http://www.contextures.com/xlDataVal02.html

    http://www.get-digital-help.com/2010...lues-in-excel/

    Your Quick Reference to Microsoft Excel Solutions
    http://www.xl-central.com/index.html

    New! Excel Recorded Webinars
    http://www.datapigtechnologies.com/ExcelMain.htm

    MS Excel: VBA Functions - Listed by Category
    MS Excel: ALL Formulas/Functions - Listed by Category

    Fuzzy Matching - new version plus explanation
    http://www.mrexcel.com/forum/excel-q...planation.html

    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

    John Walkenbach's power programming with Excel books.

    Excel 2010 Power Programming with VBA, Mr. Spreadsheet's Bookshelf

    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

    Professional Excel Development by Rob Bovey, Dennis Wallentin, Stephen Bullen, & John Green

    DonkeyOte: My Recommended Reading, Volatility
    http://www.decisionmodels.com/calcsecretsi.htm

    A list of Reference Books
    http://www.andypope.info/books/books.htm

    Sumproduct
    http://www.xldynamic.com/source/xld.SUMPRODUCT.html

    Need to understand error handling
    http://www.cpearson.com/excel/errorhandling.htm

    Excel file error message
    How to diagnose Excel file corruption and repair workbooks

    If a file cannot be repaired, consider recovering an earlier version from your file history
    https://support.microsoft.com/en-us/...8-file-history

    Arrays
    http://www.mrexcel.com/forum/showthread.php?t=390246
    http://www.cpearson.com/excel/VBAArrays.htm
    http://www.xtremevbtalk.com/showthread.php?t=296012
    http://www.vbtutor.net/vba/vba_chp21.htm
    http://excelmacromastery.com/Blog/in...-in-excel-vba/

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

    Re: New to Excel Programming and looking for learning materials

    Array Dimensions in Visual Basic - Working with Dimensions (code and graphics)
    http://msdn.microsoft.com/en-us/libr...(v=VS.80).aspx

    Visual Basic Array Tutorial written by Adam Wehmann
    http://patorjk.com/programming/tutorials/vbarrays.htm

    Shortcut Keys in Excel 2000 through 2007

    Pivot Intro
    http://peltiertech.com/Excel/Pivots/pivotstart.htm
    Office 2010 Class #36: Excel PivotTables Pivot Tables 15 examples (Data Analysis) - YouTube
    http://www.youtube.com/watch?v=qMGILHiLqr0
    Getting Started with Pivot Tables
    http://www.contextures.com/xlPivot01.html#Start
    Overview of PivotTable and PivotChart reports
    http://office.microsoft.com/en-gb/ex...010342752.aspx
    Build a Pivot Table in Excel VBA
    http://www.brainbell.com/tutorials/E...Excel_VBA.html

    Excel 2013 PowerPivot Basics #01: Introduction To PowerPivot for Excel 2013 - YouTube

    Conditional Formatting
    http://office.microsoft.com/en-001/e...102809768.aspx

    Count cells based on Conditional Formatting color?
    http://www.cpearson.com/Excel/CFColors.htm
    http://www.excelfox.com/forum/showth...atting-or-not)
    https://stackoverflow.com/questions/...ell-in-excel-2

    Email from XL - VBA
    http://www.rondebruin.nl/sendmail.htm

    Outlook VBA
    https://www.rondebruin.nl/win/section1.htm
    http://www.outlookcode.com/article.aspx?id=40
    Exporting Email Body Text to excel (using outlook 2010) VBA
    Exporting text from body of outlook email to excel
    Quickly export Outlook e-mail items to Excel - TechRepublic

    Mail a message to each person in a range
    http://www.rondebruin.nl/win/s1/outlook/bmail5.htm

    Excel VBA Dictionary – A Complete Guide
    https://excelmacromastery.com/vba-dictionary/

    Excel Function Dictionary by Peter Noneley
    http://www.xlfdic.com/
    http://www.hoffits.com/

    Function Translations
    http://www.piuha.fi/excel-function-name-translation/

    Dynamic Named Ranges
    http://www.contextures.com/xlNames01.html

    Vba to create waterfall charts
    http://peltiertech.com/excel-waterfa...bridge-charts/

    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/
    http://www.andypope.info/charts/gauge.htm
    https://exceldashboardschool.com/
    https://www.youtube.com/user/OnLinePCLearning/featured

    To create my Dashboard I use this small ebook: Create a Dashboard using PivotTable - Roger F. Silva
    https://www.amazon.com/Create-Dashbo...6600546&sr=1-3

    Excel Dashboard / Scorecard Ebook
    http://www.qimacros.com/excel-dashboard-scorecard.html

    Free dashboard training materials
    https://www.google.com.hk/search?q=I...hrome&ie=UTF-8
    https://www.youtube.com/user/OnLinePCLearning/featured

    Excel Dashboard School
    https://exceldashboardschool.com/

    Mike Alexander from Data Pig Technologies
    http://www.amazon.com/Excel-2007-Das...5564958&sr=1-1

    Templates
    http://www.cpearson.com/Excel/Topic.aspx
    http://www.contextures.com/excel-tem...lf-scores.html
    http://www.ozgrid.com/search/templates.htm
    http://www.onlinepclearning.com/
    https://www.youtube.com/user/OnLinePCLearning/featured

    Financial Model Template
    https://www.youtube.com/results?sear...finance&page=1

    Microsoft Excel Cascading Listboxes Tutorial
    http://www.youtube.com/watch?v=YAMvLJRwZdI

    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

    How to convert text to numbers in Excel
    http://support.microsoft.com/kb/291047

    How to parse data from the web - Brett Fret has a video in YouTube
    http://www.youtube.com/watch?v=6H7tBL97orE

    Excel VBA MAC shortcuts
    http://www.mrexcel.com/forum/excel-q...uts-excel.html

    http://www.internet4classrooms.com/e...yboard_mac.htm
    http://office.microsoft.com/en-us/ma...102927337.aspx

    http://office.microsoft.com/en-us/ex...010073848.aspx

    Excel VLOOKUP Multiple Sheets • My Online Training Hub

    Wise Owl Tutorials
    https://www.youtube.com/playlist?lis...3akx_gFMnpxTN5
    https://www.youtube.com/watch?v=KHO5...3akx_gFMnpxTN5

    http://msdn.microsoft.com/en-us/library/cc837974.aspx
    Merging Data from Multiple Workbooks into a Summary Workbook in Excel
    Merge data from all workbooks in a folder
    Merging a Range from Selected Workbooks
    Merging a Range from Multiple Workbooks by Column
    Merging a Range from Multiple Workbooks in a Folder with a Filter

    Filtering Horizontally, or both
    https://www.mrexcel.com/forum/excel-...izontally.html
    https://www.mrexcel.com/forum/excel-...ng-macros.html
    http://blog.livedoor.jp/andrewe/archives/50283818.html
    https://stackoverflow.com/questions/...d-horizontally
    https://chandoo.org/forum/threads/fi...tically.14283/

    You could do a Google search with “You Tube” and use the foollowing names, and/or, links:
    https://www.youtube.com/watch?v=ABXP...S5k4zsvnu2mkJC
    https://www.youtube.com/watch?v=KHO5...3akx_gFMnpxTN5
    https://www.youtube.com/watch?v=kd6Z...VH5Dq42RG9tlRP
    https://www.youtube.com/watch?v=AIhK...suD6oNDaOk3vbR
    https://www.youtube.com/watch?v=Z08z...Z_6brD5Gk1sVy_
    https://www.youtube.com/user/ExcelVbaIsFun/playlists
    https://www.youtube.com/watch?v=o_d8...lhXL_9m7EAgcMq
    https://www.youtube.com/user/ExcelVB...ort=dd&view=50
    https://www.youtube.com/playlist?lis...o2SEPBLLPGOyBz
    https://www.youtube.com/watch?v=y_1e...7lleNVtNeAhBVC
    https://www.youtube.com/watch?v=CDYk...007E847B3E6658

    Some other Threads where VBA learning was discussed:
    Basics of Excel VBA and Code writting
    Excel VBA
    http://www.excelforum.com/excel-form...ml#post4250487
    http://www.excelforum.com/excel-gene...s-for-vba.html
    https://members.excelcampus.com/a/1523/fdzAdugs

    Sending mail from Excel with CDO
    http://www.rondebruin.nl/win/s1/cdo.htm

    And, as your skills increase, try answering threads on sites like:
    http://www.mrexcel.com
    http://www.excelforum.com
    http://www.ozgrid.com
    http://www.vbaexpress.com
    http://www.excelfox.com

    If you are willing to spend money for the training, then something here should work for you...
    http://www.amazon.com/s/?ie=UTF8&key...l_5givffg47i_b

    Advanced Excel Training - Online Excel Course
    http://www.udemy.com/advanced-excel/

    Learn VBA Fast, Vol. I: Excel function design course, with practice exercises (The VBA Function Design Course Book 1)
    http://www.amazon.co.uk/dp/B00M6E8MBW

    Excel VBA Programmer Interview - Excel Test for interview
    http://www.vbaexpress.com/forum/show...mer-Interview&

    Excel tests
    http://www.excel-skills.com/demos2010/skills_test.php
    http://www.skills-assessment.net/hom...dex.aspx?e=135
    https://www.wiziq.com/tests/ms-excel

    Here is another Function translator that is extremely popular:
    http://en.excel-translator.de/functions/text/
    It will also translate Formulas as well
    http://en.excel-translator.de/translator/

    Here a couple of good blogs on the R1C1 Style Notation
    https://smurfonspreadsheets.wordpres...r1c1-notation/
    http://powerspreadsheets.com/r1c1-formular1c1-vba/

    Top ten ways to clean your data
    https://support.office.com/en-us/art...f-9cfc08a0a4e3

    Analytical reasoning test of Excel aptitude
    http://www.exceltip.com/wp-content/u...-Questions.pdf

    RegEX question - Alpha only upper case only.
    Regex Tutorialā€”From Regex 101 to Advanced Regex
    Regular Expression Tutorial - Learn How to Use Regular Expressions
    https://www.princeton.edu/~mlovett/r...xpressions.pdf

    The VBA Guide To ListObject Excel Tables
    https://www.thespreadsheetguru.com/b...t-excel-tables

    Hiding Macros
    https://www.mrexcel.com/forum/excel-...ng-macros.html

    Excel keyboard shortcuts
    http://www.asap-utilities.com/excel-tips-shortcuts.php
    A nearly complete Microsoft list, from thisoldman:
    https://support.office.com/en-us/art...9-9b7213f0040f
    This has some that aren't listed on the MS page:
    http://www.asap-utilities.com/excel-tips-shortcuts.php
    And this one:
    https://exceljet.net/keyboard-shortcuts
    Microsoft changed some shortcuts between 2003 and 2007 versions and they continue to change them.
    Menu shortcuts, get changed too.
    If you have a newer version of Excel, type Alt+d and a message will pop up: "Continue typing the menu key sequence ..."
    My favorite little known key sequences are the context menu shortcuts.
    If you're on Windows with a keyboard that has a menu key, copy a range of cells, then select a destination.
    Press the menu key (between Rt-Alt and Rt-Ctrl) then press V to paste values only, or R to paste formats only, or T to transpose+paste.

  27. #27
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Ipswich, England
    MS-Off Ver
    Office 365 (Win 10 - Work) & Office 365 Subscription Insider (Win 10 - Home)
    Posts
    39,561

    Re: New to Excel Programming and looking for learning materials

    PLEASE NOTE:

    This thread is a sticky as it has become a compendium of useful links and resources for members to use to learn VBA.

    You may post to this thread ONLY if you have a new resource to add to the list (this must NOT include advertising links - see our forum's rules).

    If you wish to thank anyone who has contributed to this thread, please do so using the reputation system by clicking on the star to the bottom left of one of their posts and leaving a 'thank you' message. Any 'thank yous' or other 'noise' posted to this thread should be reported and will be deleted. This is so that the thread remains clean and easy to navigate for all.

    Thank you all for your co-operation.
    Ali


    Enthusiastic self-taught user of MS Excel who's always learning!

    Forum Rules (updated September 2018): please read them here.
    How to use the Power Query code you've been given: help here. More about the Power suite here.
    Don't forget to say "thank you" to those who have helped you in your thread. If you wish, you can also reward them by clicking on their reputation star bottom left.

  28. #28
    Registered User
    Join Date
    06-22-2018
    Location
    South Australia
    MS-Off Ver
    Office Professional Plus 2010
    Posts
    10

    Re: New to Excel Programming and looking for learning materials

    A search on Youtube for "Excel Leila Gharani" will turn up videos on all Excel topics, including VBA from the basics to reasonably advanced.

    I've found her training style to be easy to follow and effective.

  29. #29
    Registered User
    Join Date
    02-18-2019
    Location
    Kent
    MS-Off Ver
    9
    Posts
    5

    Re: New to Excel Programming and looking for learning materials

    Can people share the templates that they have created for using the impressive formulas mentioned above?
    It be nice to have a play with, please

+ Reply to Thread

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