SKT_MSEXVBAP1 Microsoft Excel VBA Part 1

    This course introduces delegates to Visual Basic for Applications (VBA) for Microsoft Excel. It enables them to create simple code and macros using the Visual Basic language in order to automate formatting tasks and create custom functions. It is aimed at those who have a good working knowledge of Excel, but limited prior knowledge of VBA, who want to be able to automate tasks and extend the functionality of Excel further.

    Kontakt oss: Kurs@sgpartner.no

    COURSE OBJECTIVE:
    By actively participating in this course, you will learn about the following:

    •
    Using the Developer Tab.

    •
    Recording and running macros.

    •
    Swapping values in a macro.

    •
    Creating messages.

    •
    Understanding Workbook/Worksheet Objects and their properties.

    •
    Understanding how to declare Range, Cell, Row, and Column Objects.

    •
    Understanding variables such as Integers, Strings, Double and Boolean.

     

    TARGET AUDIENCE:
    This course is perfect for people who wish to gain the skills necessary to create macros and custom functions and understand the terminology and behaviour of the Visual Basic language.

    COURSE PREREQUISITES:
    To ensure your success, we recommend that you have a reasonable working knowledge of Excel or have attended the courses detailed below:

    •
    Microsoft Excel Level 1

    •
    Microsoft Excel Level 2

    •
    Microsoft Excel Level 3 or Microsoft Excel Level 4

    Software Requirements for Virtual Classroom
    If you are attending one of our Virtual Classroom courses, you will need to have Microsoft Excel 2013, 2016, 2019 or 365 (desktop version) installed on your device. You may notice differences in software if using a MAC. For the best experience we also recommend that you have two screens and a working microphone. A webcam is optional, but very much appreciated by our trainers!

    COURSE CONTENT:
    Create a Macro

    •
    Swap Values

    •
    Run Code from a Module

    •
    Macro Recorder

    •
    Use Relative References

    •
    Formula R1C1

    •
    Add a Macro to the Toolbar

    •
    Enable Macros

    •
    Protect Macro

    MsgBox

    •
    MsgBox Function

    •
    InputBox Function

    Worksheet and Worksheet Object

    •
    Path and FullName

    •
    Close and Open

    •
    Loop through Books and Sheets

    •
    Sales Calculator

    •
    Files in a Directory

    •
    Import Sheets

    •
    Programming Charts

    Range Object

    •
    Current Region

    •
    Dynamic Range

    •
    Resize

    •
    Entire Rows and Columns

    •
    Offset

    •
    From Active Cell to Last Entry

    •
    Union and Intersect

    •
    Test a Selection

    •
    Possible Football Matches

    •
    Font and Background Colours

    •
    Areas Collection and Compare Ranges

    Variables

    •
    Option Explicit

    •
    Variable Scope

    •
    Life of Variables

    •
    Type Mismatch

    FOLLOW ON COURSES:
    MSEXVBAP2 – Microsoft Excel VBA Part 2

    Tilleggsinformasjon

    Varighet

    1 dag(er)

    Språk

    Engelsk/Norsk kursmateriell, Engelsk/Norsk kursholder

    Sted

    Virtuelt (90% av våre kurs blir tatt opp)/Vi setter opp kurs over hele landet