• 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 3
      CoursesPopularMicrosoft Excel Macros & VBA Beginner Level 3
      • Getting Started 1

        • Lecture1.1
          Learning objectives
      • Variables and Constants 46

        • Lecture2.1
          Specifying a data type
        • Lecture2.2
          Specifying integral numeric data types
        • Lecture2.3
          Scientific notation – Part 1
        • Lecture2.4
          Scientific notation – Part 2
        • Lecture2.5
          Scientific Notation – Part 3
        • Lecture2.6
          Specifying non-integral numeric data types – Introduction
        • Lecture2.7
          Specifying non-integral numeric data types – Single
        • Lecture2.8
          Specifying non-integral numeric data types – Double
        • Lecture2.9
          Specifying non-integral numeric data types – Currency
        • Lecture2.10
          Floating point vs fixed point – Part 1
        • Lecture2.11
          Floating point vs fixed point – Part 2
        • Lecture2.12
          Floating point vs fixed point – Part 3
        • Lecture2.13
          Specifying non-numeric data types – String
        • Lecture2.14
          Specifying non-numeric data types – Boolean
        • Lecture2.15
          Specifying non-numeric data types – Date – Part 1
        • Lecture2.16
          Specifying non-numeric data types – Date – Part 2
        • Lecture2.17
          Specifying non-numeric data types – Date – Part 3
        • Lecture2.18
          Specifying non-numeric data types – Object – Part 1
        • Lecture2.19
          Specifying non-numeric data types – Object – Part 2
        • Lecture2.20
          Specifying non-numeric data types – Variant
        • Lecture2.21
          Review of data types
        • Lecture2.22
          Scope – Introduction
        • Lecture2.23
          Scope – Procedure level
        • Lecture2.24
          Scope – Module level
        • Lecture2.25
          Scope – Project level
        • Lecture2.26
          Scope – Global level
        • Lecture2.27
          Review of scope
        • Lecture2.28
          Declaring multiple variables with one statement
        • Lecture2.29
          Explicit vs implicit declarations – Part 1
        • Lecture2.30
          Explicit vs implicit declarations – Part 2
        • Lecture2.31
          Explicit vs implicit declarations – Part 3
        • Lecture2.32
          Explicit vs implicit declarations – Part 4
        • Lecture2.33
          Using the locals window
        • Lecture2.34
          Variables are initialized at run – Part 1
        • Lecture2.35
          Variables are initialized at run – Part 2
        • Lecture2.36
          Assigning data types to constants
        • Lecture2.37
          Declaring scope for constants
        • Lecture2.38
          Organizing variables and constants
        • Lecture2.39
          Predefined constants
        • Lecture2.40
          Enumerations
        • Lecture2.41
          Viewing information about a predefined constant
        • Lecture2.42
          Values that constants cannot be initalized to
        • Lecture2.43
          Practice assignment Part 1
        • Lecture2.44
          Practice assignment Part 2
        • Lecture2.45
          Practice assignment Part 3
        • Lecture2.46
          Practice assignment Part 4
      • Functions 12

        • Lecture3.1
          Introduction
        • Lecture3.2
          VBA function syntax
        • Lecture3.3
          Using VBA functions
        • Lecture3.4
          A function is a type of procedure
        • Lecture3.5
          Accessing help on VBA functions
        • Lecture3.6
          Qualifying a CBA function
        • Lecture3.7
          Using worksheet functions
        • Lecture3.8
          Qualifying worksheet functions
        • Lecture3.9
          MsgBox function – Syntax and arguments
        • Lecture3.10
          MsgBox function – Displaying a message only
        • Lecture3.11
          MsgBox function – Assigning the returned value to a variable
        • Lecture3.12
          MsgBox function – Coding tip!
        This content is protected, please login and enroll course to view this content!
        Prev A function is a type of procedure
        Next Qualifying a CBA function

        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?