+ Reply to Thread
Results 1 to 11 of 11

VBAs/Macros for a beginner

  1. #1
    Registered User
    Join Date
    08-22-2019
    Location
    UK
    MS-Off Ver
    Excel- 2013
    Posts
    11

    VBAs/Macros for a beginner

    Hi All.

    I am new to this forum so apologies for any mistakes/errors in advance.

    I am not sure if this is the right section to post this but here it goes.

    I have seen some people using VBAs and Macros in my previous workplace and I could sit there and watch them all day long. I am aware of the potential benefits of mastering them. If you already havent figured out I am new to VBAs/Macros and really want to learn them.

    I would really appreciate if anyone could direct me in the right path/websites/links and/or learning metarials for a beginner.

    Thanks in advance

  2. #2
    Forum Contributor
    Join Date
    06-02-2012
    Location
    London, England
    MS-Off Ver
    Excel 2010
    Posts
    146

    Re: VBAs/Macros for a beginner

    You could try starting here : https://www.excel-easy.com/vba.html

    But VBA is much easier to learn if you have a specific goal / project / problem to solve and break it down into small bits. Learn how to do each small bit (via asking questions on this forum perhaps?) and then learn how it all fits together.

    Before you know if you'll be writing code without too much trouble.

    Beth.

  3. #3
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Ipswich, England
    MS-Off Ver
    Excel 2016 (Win 10 - Work) & 365 Subscription (Win 10 - Home)
    Posts
    30,900

    Re: VBAs/Macros for a beginner

    Moved to The Water Cooler.
    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.

  4. #4
    Registered User
    Join Date
    08-22-2019
    Location
    UK
    MS-Off Ver
    Excel- 2013
    Posts
    11

    Re: VBAs/Macros for a beginner

    Thank you Beth.

    I was thinking of learning the fundementals then asking for advice on the project was my next step

  5. #5
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Ipswich, England
    MS-Off Ver
    Excel 2016 (Win 10 - Work) & 365 Subscription (Win 10 - Home)
    Posts
    30,900

    Re: VBAs/Macros for a beginner

    I think that's a good tactic, although don't be surprised if your first project takes a lot longer than expected! Make sure you allow at least three times as long as you expect.

  6. #6
    Registered User
    Join Date
    08-22-2019
    Location
    UK
    MS-Off Ver
    Excel- 2013
    Posts
    11

    Re: VBAs/Macros for a beginner

    Hi Ali,

    I am expecting it to take longer and aware that I need to invest lots of time into it so not expecting any miracles soon, plus already having read lots of threads here i also believe this forum may be the biggest help also

  7. #7
    Forum Contributor
    Join Date
    11-21-2017
    Location
    Chorley
    MS-Off Ver
    2013
    Posts
    263

    Re: VBAs/Macros for a beginner

    I agree with Beth, you're better off getting a project you want to do and then learning how to do that, rather than trying to remember a load of stuff you might never need to know.

    It's how I've learnt, and still do learn

    You already know the most important part, what can be done - You just need to get on the road to knowing how to do it.

    If you've no project in mind already but want to have a go then take a look at the Questions being asked on Forums like this and trying to come up with a soloution yourself.

    It doesn't matter if you don't solve it, it doesn't matter how you approach the soloution - Just have a go at solving it and see how far you get

  8. #8
    Forum Expert
    Join Date
    05-20-2015
    Location
    Chicago, Illinois
    MS-Off Ver
    2016
    Posts
    2,103

    Re: VBAs/Macros for a beginner

    There is a thread on this forum with a host of suggested resources:

    https://www.excelforum.com/excel-pro...materials.html

    Personally, I started by reading a John Walkenbach book - might've been VBA for Dummies? - then started poking at my own projects from there.
    If your problem has been solved, please use "Thread Tools" to mark the thread as "Solved".

    If you're grateful for this site's existence and would like to contribute to the community, please consider posting something hilarious in our joke thread:
    https://www.excelforum.com/the-water...ke-thread.html

  9. #9
    Registered User
    Join Date
    08-22-2019
    Location
    UK
    MS-Off Ver
    Excel- 2013
    Posts
    11

    Re: VBAs/Macros for a beginner

    Thankyou Cantosh, Will give that thread ago

  10. #10
    Forum Moderator Paul's Avatar
    Join Date
    02-05-2007
    Location
    Wisconsin
    MS-Off Ver
    2013
    Posts
    6,553

    Re: VBAs/Macros for a beginner

    A little late to the party, but a good way to see examples of how various tasks can be done is to use the Macro Recorder. The code generated by the recorder is often not the most efficient, but if you have to do the same things repeatedly it works well. And of course, once you know the syntax and objects/methods/etc., you'll be able to modify the generated code to conform to variations.

    For a look at a lot more details, you can use:

    Getting Started: https://docs.microsoft.com/en-us/off...-vba-in-office

    Excel Object model: https://docs.microsoft.com/en-us/off...l/object-model

    Range object example: https://docs.microsoft.com/en-us/off....range(object)

  11. #11
    Forum Guru Olly's Avatar
    Join Date
    09-10-2013
    Location
    Darlington, UK
    MS-Off Ver
    Excel 2016, 2019, 365
    Posts
    5,716

    Re: VBAs/Macros for a beginner

    Alternative viewpoint:

    Devote your energies to learning Power Query / Power Pivot, instead of VBA.
    Far more useful, far more transferable.

    let Source = #table({"Question","Thread", "User"},{{"Answered","Mark Solved", "Add Reputation"}}) in Source

    If I give you Power Query (Get & Transform Data) code, and you don't know what to do with it, then CLICK HERE

    Walking the tightrope between genius and eejit...

+ 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