• Home
  • Course Library
  • Contact
      • Cart

        0
    Have any questions?
    learn@ontracktv.com
    Login
    ontrackTVontrackTV
    • Home
    • Course Library
    • Contact
        • Cart

          0

      IT & Software

      • Home
      • All courses
      • IT & Software
      • Microsoft Excel Macros & VBA Beginner Level 1
      CoursesMicrosoftMicrosoft Excel Macros & VBA Beginner Level 1
      • Getting Started 15

        • Lecture1.1
          Introduction to Excel Macros and VBA
        • Lecture1.2
          What is VBA?
        • Lecture1.3
          What VBA is not!
        • Lecture1.4
          Essential VBA terminology
        • Lecture1.5
          What is a macro (aka sub procedure)?
        • Lecture1.6
          How are macros created?
        • Lecture1.7
          Where is VBA coding done?
        • Lecture1.8
          Where are macros stored?
        • Lecture1.9
          Macro-enabled workbooks
        • Lecture1.10
          Accessing macros
        • Lecture1.11
          The PERSONAL.XLSB workbook
        • Lecture1.12
          Not all macros are “good”
        • Lecture1.13
          Macro security settings
        • Lecture1.14
          Setting up a trusted location
        • Lecture1.15
          Getting started – Review
      • Creating a Macro 22

        • Lecture2.1
          Introduction to creating a macro
        • Lecture2.2
          Displaying the Developer tab
        • Lecture2.3
          Saving as a macro-enabled workbook
        • Lecture2.4
          Launching the Visual Basic Editor (VBE)
        • Lecture2.5
          Setting up the VBE interface
        • Lecture2.6
          Project Explorer window – Part 1
        • Lecture2.7
          Project Explorer window – Part 2
        • Lecture2.8
          Inserting a module
        • Lecture2.9
          Renaming and deleting a module
        • Lecture2.10
          Basic syntax to start and end a macro
        • Lecture2.11
          Naming your macro
        • Lecture2.12
          Declaring the start and end of a macro
        • Lecture2.13
          Writing the instructions – Part 1
        • Lecture2.14
          Writing the instructions – Part 2
        • Lecture2.15
          Writing the instructions – Part 3
        • Lecture2.16
          Automatic formatting
        • Lecture2.17
          The line continuation character
        • Lecture2.18
          Inserting comments
        • Lecture2.19
          Converting multiple lines into comments
        • Lecture2.20
          Inserting blank lines
        • Lecture2.21
          Auto syntax check
        • Lecture2.22
          Creating a macro – Review
      • Running a Macro 11

        • Lecture3.1
          Introduction to running a macro
        • Lecture3.2
          Before you run a macro
        • Lecture3.3
          Using the Run Sub/User Form command
        • Lecture3.4
          Using the Macros list – Part 1
        • Lecture3.5
          Using the Macros list – Part 2
        • Lecture3.6
          Using a keyboard shortcut
        • Lecture3.7
          Creating a command button to run a macro
        • Lecture3.8
          Creating a graphical object or button control to run a macro
        • Lecture3.9
          Compile errors
        • Lecture3.10
          Run time errors
        • Lecture3.11
          Running a macro – Review
      • Using the Macro Recorder 37

        • Lecture4.1
          Introduction to using the macro recorder
        • Lecture4.2
          Practicing before you use the Macro Recorder
        • Lecture4.3
          Absolute vs relative mode
        • Lecture4.4
          Recording the macro
        • Lecture4.5
          Running the macro
        • Lecture4.6
          Viewing the VBA code
        • Lecture4.7
          Editing the VBA code
        • Lecture4.8
          Deleting the macro
        • Lecture4.9
          Avoiding a common mistake – Part 1
        • Lecture4.10
          Avoiding a common mistake – Part 2
        • Lecture4.11
          Avoiding a common mistake – Part 3
        • Lecture4.12
          Avoiding a common mistake – Part 4
        • Lecture4.13
          Viewing VBA statements generated in real time
        • Lecture4.14
          Selecting a range of any size
        • Lecture4.15
          Creating a macro that formats a range of any size
        • Lecture4.16
          Using CTRL + A in relative mode
        • Lecture4.17
          Using CTRL + A in absolute mode
        • Lecture4.18
          Navigating to the end of a range of any size
        • Lecture4.19
          Inserting SUM at the end of a column of any size
        • Lecture4.20
          Another way to navigate to the end of a column of any size
        • Lecture4.21
          When does a new module get created?
        • Lecture4.22
          Generating the PERSONAL.XLSB workbook
        • Lecture4.23
          Storing a macro in the PERSONAL.XLSB workbook
        • Lecture4.24
          Unhiding or hiding the PERSONAL.XLSB workbook
        • Lecture4.25
          Deleting the PERSONAL.XLSB workbook
        • Lecture4.26
          A super useful tip!
        • Lecture4.27
          Using AutoSum during a recording
        • Lecture4.28
          AutoSum in absolute referencing mode – Part 1
        • Lecture4.29
          AutoSum in absolute referencing mode – Part 2
        • Lecture4.30
          AutoSum in relative referencing mode
        • Lecture4.31
          The verdict on using AutoSum
        • Lecture4.32
          Creating a macro that imports data – Part 1
        • Lecture4.33
          Creating a macro that imports data – Part 2
        • Lecture4.34
          Creating a macro that imports data – Part 3
        • Lecture4.35
          Creating a macro that imports data – Part 4
        • Lecture4.36
          Creating a macro that imports data – Part 5
        • Lecture4.37
          Using the Macro Recorder – Review
      • Debugging a Macro 12

        • Lecture5.1
          Creating a macro for debugging purposes
        • Lecture5.2
          Testing the macro
        • Lecture5.3
          Stepping into the VBA code
        • Lecture5.4
          What is a breakpoint?
        • Lecture5.5
          Inserting and removing breakpoints
        • Lecture5.6
          Using Step Into and breakpoints
        • Lecture5.7
          Using Run to Cursor
        • Lecture5.8
          What is compiling?
        • Lecture5.9
          What happens when a compile error occurs?
        • Lecture5.10
          Using the Compile VBAProject command
        • Lecture5.11
          Changing the Editor Format options
        • Lecture5.12
          Final words

        Saving as a macro-enabled workbook

        Prev Displaying the Developer tab
        Next Launching the Visual Basic Editor (VBE)

        Leave A Reply Cancel reply

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

        All Courses

        • Adobe
        • IT & Software
        • Microsoft
        • Popular
        • Social Media

        Latest Courses

        Microsoft Excel 2016 Intermediate Level 1

        Microsoft Excel 2016 Intermediate Level 1

        Free
        Microsoft Excel Macros & VBA Beginner Level 3

        Microsoft Excel Macros & VBA Beginner Level 3

        Free
        Microsoft Excel Macros & VBA Beginner Level 2

        Microsoft Excel Macros & VBA Beginner Level 2

        Free

        Copyright 2020 ontrackTV - A division of Quizam Media Corporation

        • Sign in

        Forgot your password?

        Lost your password? Please enter your email address. You will receive mail with link to set new password.

        Back to login

        Login with your site account

        Lost your password?