How to use Excel VBA

Excel VBA allows you to automate various activities you do in Excel.

  1. article Completed

    Introduction to VBA Excel

    Excel VBA allows you to automate various activities you do in Excel. We use Excel to analyze data, create reports, prepare charts & presentations, do calculations and understand information. When we are doing all these, we spend quite some time, repeating same steps.VBA helps you not repeat these steps.

    Edit Remove Move
  2. video Completed

    Recorded Macro Basics

    1.How to Record a Macro <br>2.Macro = VBA code <br>3.Macros are great for repetitive tasks<br>&nbsp;4.What file extension to use for Excel 2007: .xlsm <br>5.How to show Developer Ribbon in Excel 2007<br>6.Relative and Absolute References in Excel Macros <br>7.Paste Special Values Absolute Macro<br><br>This tutorial offers you seven different concepts to learn. &nbsp;It is very helpful for learning VBA.

    Edit Remove Move
  3. video Completed

    Macro Security

    In this video you will learn about Macro Security, this is a beginning to advanced Excel class. Great way to learn a mixture and see what is in or out of your league.&nbsp;

    Edit Remove Move
  4. video Completed

    Relative & Absolute Macro Recorder

    1.Relative &amp; Absolute button in the Developer Ribbon <br>2.The fact that the Relative &amp; Absolute button governs selection movement when recording a Macro <br>3.The fact that the cell references in Formulas created during a Recorded Macro are governed by the dollar signs&nbsp;<br><br>This is a great video to learn from. I highly suggest watching the video.

    Edit Remove Move
  5. video Completed

    Excel VBA code From Internet

    &nbsp;1.Formatting a simple Static Report (Common Macro task in the working world) <br>2.Posting question to Mr Excel Message Board to get VBA code 3.Search Google for Excel VBA code <br>4.Copy code from internet and paste into VBA editor window 5.Open VBA editor <br>6.Insert VBA<br><br>Pretty basic steps you will learn in this video.

    Edit Remove Move
  6. video Completed

    Click Button To Move Data To Table On Another Sheet

    1. Enter Data On One Sheet and then click Button To Send Data To Table on Second Sheet <br>2. Recorded Macro: Move Record From Data Entry Sheet To Table On Second Sheet <br>3. Learn how to Show Developer Ribbon (Excel 2010 = Right-click Ribbon, Customize Ribbon, Checkbox for Developer Ribbon)&nbsp;<br><br>This is basic and a very easy concept to grab. &nbsp;The video will help if your a beginner. &nbsp;

    Edit Remove Move
  7. video Completed

    Macro to Remove Rows

    See how to remove rows of a table where the row has a blank in column A using a Macro. This is very basic and helpful when you figure out how to do it.

    Edit Remove Move
  8. video Completed

    VBA Code for Relative & Absolute Macro

    Part 2 Look at the code for the Macro created in YTLE#89: Relative &amp; Absolute Macro together. Look at VBA editor window. Look at the module where the Macro is stored. This is a great video it is on the&nbsp;more advanced side, but very helpful.

    Edit Remove Move
  9. video Completed

    VBA Code for Relative & Absolute Macro

    Part 2 Look at the code for the Macro created in YTLE#89: Relative &amp; Absolute Macro together. Look at VBA editor window. Look at the module where the Macro is stored. This is a great video it is on the&nbsp;more advanced side, but very helpful.

    Edit Remove Move
  10. video Completed

    Edit Recorded Macro

    See how to record a MACRO to copy data to a new location, and then edit the code. See the VBA functions RANGE and OFFSET. Edit Recorded Macro. Record Absolute and Relative Macro.

    Edit Remove Move
  11. video Completed

    Advanced Filter Extract Text

    See how to create a macro that will do an Advanced Filter Movie Title Extract for a Movie Database. See how to create the TRUE FALSE formula for advanced filter before creating a Macro and then adding the Macro to a Form Command button.

    Edit Remove Move
  12. video Completed

    Macro Advanced Filter Extract B-days

    This video shows the MACRO and Advanced Filter and the Forms button. See the INDIRECT, ROW, TEXT and OR functions in a TRUE FALSE formula that will help to extract records of people who have a birthday in the next 14 days.

    Edit Remove Move
  13. video Completed

    Macro Data Validation from 3 lists

    Create a MACRO using Relative and Absolute cell references in order to create a Data Validation List from 3 separate lists on 3 separate (different) worksheets. A good video to watch if you want to see the logic of when to use a Relative Macro and when to use a Absolute Macro.

    Edit Remove Move
  14. video Completed

    Advanced Filter Data Extract 1criter

    Macro and Advanced Filter. See how to use Advanced Filter to extract records from a table with 1 criteria, then use a Macro to automatic it. Related Videos: Excel Magic Trick 185 Dynamic Formula Extract Data 1 criteria Excel Magic Trick #81: Advanced Filter AND OR Data Extract

    Edit Remove Move

Continue learning by following more paths or create your own. Join for FREE

By clicking 'Get Started Free' you agree to our Terms of Service and Privacy Policy