1. Welcome to Chandoo.org Forums. Short message for you

    Hi Guest,

    Thanks for joining Chandoo.org forums. We are here to make you awesome in Excel. Before you post your first question, please read this short introduction guide. When posting or responding to questions please remember our values at Chandoo.org are: Humility, Passion, Fun, Awesomeness, Simplicity, Sharing Remember that we have people here for whom English is not there first language and we need to allow for this in our dealings.

    Yours,
    Chandoo
  2. Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  3. When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Recommendations for learning Macros and VBA

Discussion in 'VBA Macros' started by adamuce, Jul 12, 2018.

  1. adamuce

    adamuce New Member

    Messages:
    23
    Hi Guys,

    I know there are tonnes of material out there but was looking for recommendations.

    I have tried doing excel tutorials but I find it rather complex. I would like some recommendations for a place which is much simpler.

    Thanks in advance
  2. Marc L

    Marc L Excel Ninja

    Messages:
    4,258
    Hi !

    As tutorials are often the best way to learn …
    As it is just about reading …
    Compare tutorials or forums' code with the VBA inner help.

    Another way : activate the Macro Recorder and operate manually
    with Excel inner features : you will get a code base.
    Then for each unknown code keyword, see in the VBA inner help …
    Compare also this generated code with tutorials
    or solutions in forums in order to learn how to optimize it
    to avoid any not necessary stuff like Activate, Select, …
    which slow down the execution.

    The more you will know Excel, the more easier your VBA codes will be …
    ThrottleWorks and Chirag R Raval like this.
  3. adamuce

    adamuce New Member

    Messages:
    23
    Thanks for your reply and advice. MS Excel's tutorial on VBA was not very easy for me to understand, although MS Excel's tutorials on formulas I have used in the past.
  4. Marc L

    Marc L Excel Ninja

    Messages:
    4,258
    adamuce likes this.
  5. adamuce

    adamuce New Member

    Messages:
    23
    Thanks again for your prompt response. I was looking for even more basic than that. I have no idea what those things mean. However once I get the basics I think I can progress onto such things. :D
  6. Marc L

    Marc L Excel Ninja

    Messages:
    4,258
    First for any VBA need, respect the main TEBV rule :
    Think Excel Before VBA !
    Just asking yourself : « What Excel can do for me ? »
    As sometimes just with Excel basics a code is even not really needed …

    I already met algorhithmic VBA codes needing a very long time to execute
    as they didn't follow any Excel logic (its basics / inner features)
    but just operating manually Excel basics it needed just a few seconds !
    So a procedure reproducing the same way is far faster to execute
    and easier to maintain …

    What is the best code ?
    The one you first are able to understand and to maintain !
    But before it needs reading, practicing, reading & practicing again …
    ThrottleWorks and Chirag R Raval like this.
  7. Chihiro

    Chihiro Excel Ninja

    Messages:
    5,057
  8. Hui

    Hui Excel Ninja Staff Member

    Messages:
    11,639
    ThrottleWorks likes this.
  9. adamuce

    adamuce New Member

    Messages:
    23
  10. adamuce

    adamuce New Member

    Messages:
    23
    Thanks for your reply. Just downloaded a guide. Will look into it
  11. Hui

    Hui Excel Ninja Staff Member

    Messages:
    11,639
    If you register there you will get an email in regards to the weekly webinar's, which aren't always weekly.

    This is a huge resource of high quality material with real life examples
    ThrottleWorks likes this.
  12. Chirag R Raval

    Chirag R Raval Member

    Messages:
    655
    Dear all,

    Strait forward & effactive stream of knowledge to
    Understand this thing may be near cover all possible aspect of
    Excel VBA is here www.globaliconnect.com.

    Repeat reading about same concept about Object, Property & Method's,
    loops ,Statements,Arrays,,Collections,and many more basic
    become helpful on stay & increase understanding & knowledge in mind.

    I refer videos on wiseowl.com about Excel VBA
    Its Spread more knowledge in mind about how to thing works practically
    Is very helpful if repeated viewing with concentration.repetation explore
    More & more knowledge about any concept.

    Hope this will helpful.

    Regards

    Chirag Raval
    ThrottleWorks likes this.

Share This Page