Creating a simple macro in Excel 2010 – Part 2




About this tutorial:

Video duration: 9:4
Creating a simple macro in Excel 2010 – Part 2. In this video you will see how to create a button on your worksheet to trigger your macros.

To download the course materials, sample Excel files used in the videos and the handouts for the course, please visit –

Post Author: OfficeTutes.com

Apple lover, ICT and LEAN consultant, MS Office lecturer My other website with video tutorials - Tutorials, guides and news for iPhones and iPads

34 thoughts on “Creating a simple macro in Excel 2010 – Part 2

    InfoTech Institute of Knowledge Haroa

    (January 14, 2019 - 12:15 am)

    sample Excel files link – http://excelandaccesstraining.net- NOT WORKING

    Faisal Mohamed

    (January 14, 2019 - 12:15 am)

    All your video sessions are easy to understand. Thanks a lot

    tanima mukherjee

    (January 14, 2019 - 12:15 am)

    Really nice video. I thought that macro is for very advance level. But it seems easy. Thank you.

    Ashok K

    (January 14, 2019 - 12:15 am)

    Thanks

    Joy Banerjee

    (January 14, 2019 - 12:15 am)

    The restore button is not macro'd

    Maria Vasquez

    (January 14, 2019 - 12:15 am)

    This video looks very interesting, but it does not have voice soun

    renee1739

    (January 14, 2019 - 12:15 am)

    the website does not work

    hasaninlondon

    (January 14, 2019 - 12:15 am)

    That was easy stuff, I always thought Macros was some super difficult thing that only super smart people can do! lol

    NOUMAN SHAFQAT

    (January 14, 2019 - 12:15 am)

    Great video.. Just last Macro Restore All not assigned Properly :-p

    Deba Do It

    (January 14, 2019 - 12:15 am)

    Excellent!

    Umbrella Watch

    (January 14, 2019 - 12:15 am)

    thx great job. just used this for work 🙂 wooot.

    Jed Hooper

    (January 14, 2019 - 12:15 am)

    Thank you putting this macro class on you tube. Great way to learn or review on your own time schedule.

    january miner

    (January 14, 2019 - 12:15 am)

    Plain and simple! Thanks!

    Arturo Perez

    (January 14, 2019 - 12:15 am)

    This is great!

    andrew chioco

    (January 14, 2019 - 12:15 am)

    you forgot to assign "restore macro" to the third button.. ^^V hehehe anyways great tutorial..

    Agi GS Retail

    (January 14, 2019 - 12:15 am)

    Can we add a print command to macro button? or save command. as in a button labelled "submit", when we click the button, then the sheet will automatically saved, printed and then closed and then automatically pop up a new blank sheet.

    Nadine Beard

    (January 14, 2019 - 12:15 am)

    Very clear.  A couple of things.  You referenced Cell A5, when you were in Cell A1, and as mentioned by others, didn't reassign the copied Macro.  Thanks so much for sharing!

    Thong LeMinh

    (January 14, 2019 - 12:15 am)

    Perfect lesson, so easy to understand. Thank you very much.

    Thong LeMinh

    (January 14, 2019 - 12:15 am)

    Perfect lesson, so easy to understand. Thank you very much.

    Lucian Liu

    (January 14, 2019 - 12:15 am)

    Thank you so much! it was very helpful!

    David H

    (January 14, 2019 - 12:15 am)

    Hello here. Is there any way how to fix position of macros? WHen you press Dept totals it moves to the right because of new column ( 1, 2,3 ) on the left side. I just wanna them in the same position and dont move to the right with mouse. 

    Masudur Rahman

    (January 14, 2019 - 12:15 am)

    good job

    Artur Ago

    (January 14, 2019 - 12:15 am)

    RESTORE ALL did not run correctly because the 3rd button (copied from the 1st one) was not assigned to the third macro; it was changed the name, only!

    David Victor

    (January 14, 2019 - 12:15 am)

    Thanks for the video. I want to cut a line (such as an address line) and then insert it into another worksheet or workbook; like creating a database. The problem is that the number of lines above it keeps changing as well as it also contains a separate & growing database. Is there a way to "name" a field of cells and tell the macro to go there and then add the information I want? (I remember lotus 123 back in college. Don't know if excel has these features or something like it)

    Iain Tubemogrifier

    (January 14, 2019 - 12:15 am)

    Many thanks for making something so useful, so simple!

    idon kok

    (January 14, 2019 - 12:15 am)

    exelent. sorry my english.. tank for these videos

    HurricaneGregor

    (January 14, 2019 - 12:15 am)

    Whoops, you forgot to assign the Restore macro to the Restore All button 🙂
    Thanks for the videos, they're quite informative.

    lingsun21

    (January 14, 2019 - 12:15 am)

    Thank you so much, sir! This video is so good! It's easy to understand, easy to learn. Hats off to you.

    Jenny Taylor

    (January 14, 2019 - 12:15 am)

    the website no longer works??????????????

    NotSoBlu

    (January 14, 2019 - 12:15 am)

    Thank for this well explained tutorial.
    I have a question and I woonder if you're able to assist me. This is regarding setting up a macro (activated by a button) that would run a function within a Data Validation List. Is this possible? I followed the process you presented in this tutorial and it works excelent on any standard cell, except if I have a 'drop-down' list set up in Data Validation. Can you help me.
    I appreciate your time and responce. Thank you.

    corunnery

    (January 14, 2019 - 12:15 am)

    I have a question. So say you e-mail this spreadsheet, would those macro functions transfer with the rest of the chart?

    tase25

    (January 14, 2019 - 12:15 am)

    Great vid. Lots of help and easy to follow

    mo1001

    (January 14, 2019 - 12:15 am)

    People who know how to use macros are basically regarded as wizards in most offices

    mohit diwan

    (January 14, 2019 - 12:15 am)

    Please update the video in which 'Restore All' button is assigned a 'Restore' macro. Its useful but can be misleading to some people.

Leave a Reply

Your email address will not be published. Required fields are marked *