Results 1 to 8 of 8

How long does it take to properly learn VBA?

This is a discussion on How long does it take to properly learn VBA? within the General Excel Discussion & Other Questions forums, part of the Question Forums category; Mods - I hope this is in the right forum. Please feel free to move if needed I've been writing ...

  1. #1
    Board Regular
    Join Date
    Mar 2007
    Posts
    589

    Question How long does it take to properly learn VBA?

    Mods - I hope this is in the right forum. Please feel free to move if needed

    I've been writing macros for about a total of two months within the past year. I have never written code before, and have never taken a formal programming class (I don't count HTML real programming). And I have never been good at advanced math.

    I generally regard myself as a smart guy, but I admit that I am not that creative. My analytical side is way more developed than my creative side. I often struggle mightily writing the most simple code not because I don't know what needs to happen, I simply cannot put to code my thoughts. I get through most of it by being resourceful (here :D ), patient, and having a strong desire to succeed.

    In that span I've created some pretty awesome macros to help my team at work. VBA is definitely a means to an end. Thanks to the many here that has helped me tremendously.

    Enough babbling by me. VBA is coming to me very slowly. I learn bits and pieces all the time, but I know I cant learn something specifically unless I am tasked to do it. At this rate, it feels like it will be forever before I get comfortable doing it.

    How long did it take you guys who didn't have prior programming experience before it all came together for you and "clicked"? Am I just slow, or is it normal for this stuff to take time before you fully understand it?

  2. #2
    MrExcel MVP
    Moderator
    Rediscovering the love
    Richard Schollar's Avatar
    Join Date
    Apr 2005
    Location
    UK
    Posts
    23,678

    Default Re: How long does it take to properly learn VBA?

    Hi

    It took me a couple of years of plugging away with VBA to get really comfortable. Most of what I learned, I learned from this Board (especially answering others' questions) - I think it's a great resource because it can provide you with a problem that needs solving that you can stab away at until it is solved (which goes some way to helping with your comment "but I know I cant learn something specifically unless I am tasked to do it").
    Richard Schollar

    Using xl2013

  3. #3
    Board Regular
    Join Date
    Aug 2002
    Location
    Thailand
    Posts
    565

    Default Re: How long does it take to properly learn VBA?

    99% of most anything can be done with the basic programming statements if/then, while/wend, do/while, for/next etc....

    The 'programming' logic is not that hard to learn. You don't need advanced math. You just need logic.

    What gets most people is learning the different application object models. That just takes experience. The better you know an app, the more 'objects' you'll be aware of and the easier it is to program in VBA as you just need to find the correct grammar to manipulate the object you want. In a nutshell, there may be 5 different ways to do the same thing. Question is which is the best? The more you know about the app, the easier it becomes.

    Unfortunately it doesn't help that the VB MS Office Application Object Models all started out from different places so the object models across apps are not truly in sync, but they are a lot better now than it was in the past!

    Took me 5-weeks in Word from knowing nothing (but I was an expert Word user). Delivered a fully functioning presentation system that went international which interfaced with a document management system. Big caveat though as I was programming since I was in Grade school. So I knew programming and I knew the app, just needed to figure out the proper program "grammer".
    g-
    gwkenny@Fin-ITSolutions.com
    ___________________________________

  4. #4
    MrExcel MVP
    Moderator
    SydneyGeek's Avatar
    Join Date
    Aug 2003
    Location
    Sydney, Australia
    Posts
    12,215

    Default Re: How long does it take to properly learn VBA?

    As the others have mentioned, it takes time but it takes less time if you get expert help or access to good examples (eg, via this Board) and you will get further if you have a real problem to solve.

    You never really stop learning; you just get to the point where your toolbox is big enough for you to be able to consider VBA as a productivity enhancer, not a drain on your time and resources.

    Denis
    Self-preservation: For when you've got yourself in a jam
    ------------------------------------------------------
    My site contains a number of Excel and Access Resources

  5. #5
    Board Regular Domski's Avatar
    Join Date
    Jan 2005
    Location
    Leeds, UK
    Posts
    7,178

    Default Re: How long does it take to properly learn VBA?

    The 'programming' logic is not that hard to learn. You don't need advanced math. You just need logic.
    I agree with this, my maths is appalling .

    I think experience of programming in the past is a definite advantage, not one that I have alas. I'd also recommend a good book on Excel VBA programming. There are quite a few about.

    In the past I haven't done a lot of VBA as my job didn't call for it a great deal but I still think I've learnt a lot over the last year or so from messing about with problems posted on here. I've now been given a lot more work (and no more staff) that fortunately is of a type can can be automated so for the next couple of months I'm going to be pretty full on with it.

    Personally, I like to try and work out problems for myself before resorting to the board but it's often worth checking things out here as there are loads of really good VBA guys here that will demonstrate how to avoid bad habits that you might get into or ideas you may not have even contemplated.

    Like anything some people take to it faster than others but if you persevere you'll get there I'm sure.

    Dom
    "May the fleas of a thousand camels infest the crotch of the person who screws up your day and may their arms be too short to scratch..."

    - Guidelines For Posting

    - Mr Excel Articles and PodCasts

    - Display sheet using HTML Maker or Excel Jeanie

    - Something that makes me laugh

    - Please try to remember to use code tags when posting your VBA code: [code] Your code here [/code]

  6. #6
    MrExcel MVP
    Moderator
    Rediscovering the love
    Richard Schollar's Avatar
    Join Date
    Apr 2005
    Location
    UK
    Posts
    23,678

    Default Re: How long does it take to properly learn VBA?

    Quote Originally Posted by Domski View Post
    I agree with this, my maths is appalling .
    Unlike mine, which is superb - in fact probably better than the other 23 people who have replied to this thread
    Richard Schollar

    Using xl2013

  7. #7
    MrExcel MVP
    Moderator
    SydneyGeek's Avatar
    Join Date
    Aug 2003
    Location
    Sydney, Australia
    Posts
    12,215

    Default Re: How long does it take to properly learn VBA?

    Hi Richard, good to see your skills are as strong as ever!

    That wasn't 2+3 was it?

    Denis
    Self-preservation: For when you've got yourself in a jam
    ------------------------------------------------------
    My site contains a number of Excel and Access Resources

  8. #8
    Board Regular Domski's Avatar
    Join Date
    Jan 2005
    Location
    Leeds, UK
    Posts
    7,178

    Default Re: How long does it take to properly learn VBA?

    Quote Originally Posted by SydneyGeek View Post
    Hi Richard, good to see your skills are as strong as ever!

    That wasn't 2+3 was it?

    Denis
    Which would have been wrong anyway.

    Dom
    "May the fleas of a thousand camels infest the crotch of the person who screws up your day and may their arms be too short to scratch..."

    - Guidelines For Posting

    - Mr Excel Articles and PodCasts

    - Display sheet using HTML Maker or Excel Jeanie

    - Something that makes me laugh

    - Please try to remember to use code tags when posting your VBA code: [code] Your code here [/code]

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