+ Reply to Thread
Results 1 to 2 of 2

Besides playing around with Excel, any recommendations?

  1. #1
    Registered User
    Join Date
    04-24-2020
    Location
    USA
    MS-Off Ver
    WA
    Posts
    64

    Besides playing around with Excel, any recommendations?

    Excel Ninjas,

    I really would like to know how one can become efficient and be on the same level as some experts in this forum when it comes to all things excel. I am interested in the VBA portion of it, maybe not so much on the typical excel crunch. What sources would you recommend for newbies to read up on, or be part of? What is one thing that you had to do to be where you are at this point in your joiurney? Any bits of advise is to me a golden nuggets. I am open to all suggestions and recommendations.

    Thank you all!

  2. #2
    Forum Guru
    Join Date
    04-13-2005
    Location
    North America
    MS-Off Ver
    2002/XP and 2007
    Posts
    15,827

    Re: Besides playing around with Excel, any recommendations?

    I am interested in the VBA portion of it, maybe not so much on the typical excel crunch.
    VBA is kind of a dying language -- MS Office is the only thing really keeping it alive. I don't know how committed Microsoft is to keeping VBA going. If you are only interested in the programming language and not the stuff that the spreadsheet can do, it might be better to learn a stand alone programming language that looks more viable going forward.

    That said, if you want to learn VBA, I see several general things to learn and resources to learn from:

    1) Like any programming language, there's a generic "learning to program" step that is mostly about learning how to break a task down into steps and understanding the programming structures that are common to most programming languages -- inputs, outputs, variables, arrays, math operations, text operations, loop structures, decision structures, error trapping and debugging, etc.
    2) You need to learn the statements and their syntax that are specific to the language you want to learn. I frequently refer to a reference like this: https://docs.microsoft.com/en-us/off...uage-reference
    3) Because VBA is so tightly knit with Office applications, one usually needs to learn Excel's (and other applications as needed) object model for interacting with Excel. https://docs.microsoft.com/en-us/off...l/object-model Of course, if you are not worried about the spreadsheet and may never interact with Excel from VBA, then maybe this isn't very important.
    4) From VBA, normally one does most of their input/output from/to the spreadsheet, which means interacting with the spreadsheet's range object https://docs.microsoft.com/en-us/off....range(object) Assuming you will use the spreadsheet for input and output, there is probably some value in starting small and learn how to read and write data from and to spreadsheet cells.
    5) From there work on more and more complex procedures.
    6) Half of programming is debugging, so you will want to quickly become familiar with VBA's build in debugging tools: http://www.cpearson.com/excel/DebuggingVBA.aspx

    It's a lot to learn, but start small and work your way larger. It can sometimes be helpful to use the macro recorder to get a sense of the syntax needed for accessing a specific object, property, or method.
    Quote Originally Posted by shg
    Mathematics is the native language of the natural world. Just trying to become literate.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Excel Excersises Online (Recommendations)
    By CallumWebley in forum Excel General
    Replies: 2
    Last Post: 08-26-2015, 03:00 PM
  2. Excel VBA book recommendations?
    By kenab1 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 01-21-2010, 02:29 PM
  3. Excel Training Courses - Any recommendations?
    By Simon1185 in forum Excel General
    Replies: 2
    Last Post: 05-13-2009, 04:32 AM
  4. Any recommendations on a good VBA Excel book?
    By caliskier in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 10-31-2007, 07:23 PM
  5. Replies: 2
    Last Post: 04-23-2006, 10:00 PM
  6. Recommendations for learning about Excel Macros
    By gjpcoach in forum Excel General
    Replies: 4
    Last Post: 02-25-2006, 04:42 AM
  7. Any recommendations for excel on handheld?
    By Rodney in forum Excel - New Users/Basics
    Replies: 2
    Last Post: 09-27-2005, 08:05 PM

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