We're aware that some users are experiencing technical issues which the team are working to resolve. See the Community Noticeboard for more info. Thank you for your patience.
📨 Have you signed up to the Forum's new Email Digest yet? Get a selection of trending threads sent straight to your inbox daily, weekly or monthly!

Excel Macros

Options
shaz77_2
shaz77_2 Posts: 1,881 Forumite
Hi,

Does anyone know any good tutorials for beginners on this topic?

Thanks

Comments

  • Mr_Toad
    Mr_Toad Posts: 2,462 Forumite
    Get onto Youtube and search for Mr Excel.

    There are loads of others some good, some dire but he's pretty good.
    One by one the penguins are slowly stealing my sanity.
  • Agrajag
    Agrajag Posts: 86 Forumite
    Part of the Furniture 10 Posts Combo Breaker
    edited 22 July 2015 at 3:42PM
    http://www.excel-easy.com/vba/create-a-macro.html#visual-basic-editor is a nice basic start, then you can use the headings on the right to go further.

    One tip I still use all the time is to record a Macro.
    To do this varies with the Excel version. In Excel 2010, at the bottom left of the excel worksheet, beside the word 'Ready' is a button. Press it and a dialog will ask you to name the macro - leave it as macro1 for the moment.
    The manually do some of the stuff you want to automate.
    When finished, click the button again, them go look at the code it has generated (see the link above for opening and viewing code)
    The main reason to do this is to work out the names of the objects you need to refer to when writing your macro. So if you manually change the style of a line on a graph while recording, you can easily see the syntax needed to change it automatically to something else, or change ALL the lines in the graph. It saves a great deal of wading through Object definitions, which can be daunting if you are a beginner



    Macros in excel are written in a language called VBA - search for that and you will get LOADS of info.
  • Le_Kirk
    Le_Kirk Posts: 24,511 Forumite
    Part of the Furniture 10,000 Posts Photogenic Name Dropper
    I would agree that using Macro auto record is the way to go. If that is all you need then stop there but if you want to go on to write your own Macros then check the visual basic (VBA) of the Macro you have just recorded. If you do end up looking for VBA tutorials on t'Internet, be wary of some of them as they have rubbish on their sites. Mr. Excel though, is safe and gives useful advice. I had to write some complicated programmes for some stuff I was doing at work and I found the best way was to try it myself and when that didn't work correctly or exactly, ask the exact question on the VBA forums but include the program you had written. That way posters would advise you where you had gone wrong.
This discussion has been closed.
Meet your Ambassadors

🚀 Getting Started

Hi new member!

Our Getting Started Guide will help you get the most out of the Forum

Categories

  • All Categories
  • 350.9K Banking & Borrowing
  • 253.1K Reduce Debt & Boost Income
  • 453.5K Spending & Discounts
  • 243.9K Work, Benefits & Business
  • 598.7K Mortgages, Homes & Bills
  • 176.9K Life & Family
  • 257.1K Travel & Transport
  • 1.5M Hobbies & Leisure
  • 16.1K Discuss & Feedback
  • 37.6K Read-Only Boards

Is this how you want to be seen?

We see you are using a default avatar. It takes only a few seconds to pick a picture.