Course

Inhouse

Price on request

Description

  • Type

    Course

  • Methodology

    Inhouse

  • Duration

    1 Day

Anyone wishing to automate common worksheet operations, convert worksheets into forms and understand Excel VBA code.

Important information

Government funding available

About this course

This is
a generic VBA course and is suitable for users of any version of
Microsoft Excel VBA.  You need to have a good working knowledge
of Excel.

Questions & Answers

Add your question

Our advisors and other users will be able to reply to you

Who would you like to address this question to?

Fill in your details to get a reply

We will only publish your name and question

Reviews

Course programme

DESCRIPTION
Anyone wishing to automate common worksheet operations, convert worksheets into forms and understand Excel VBA code.

PREREQUISITES
This is a generic VBA course and is suitable for users of any version of Microsoft Excel VBA. You need to have a good working knowledge of Excel.


MACROS
  • Running Macros
  • Where macros are stored
  • Assigning macros to buttons or a custom toolbar
  • Recording Macros
    • Entering a list of people's names
    • Formatting a cell
    • Adding a Header and Footer
    • Naming the three sheets
    • Inserting three more sheets and naming them
    • Running an Advanced Filter
    • Inserting a Logo
    • Exporting a Sheet to text
    • Create a Pivot Table
    • Protect a sheet with a password
    • Copy a range and paste the values into a new workbook
    • Open, Close, Save a workbook
TTHE VBA ENVIRONMENT
  • The Screen Components

    • Project Explorer
    • Project Properties
    • The Code Window
    • The Immediate Window
    • Finding Macros

  • Export and Import VBA Modules
  • Add and Remove a module
ANALYSING VBA
  • Understanding the macro results
  • Understanding Code Formatting (Indents, etc)
  • Reading from and writing to a cell
  • Absolute vs Relative Referencing
  • Playing back VBA

    • Stepping through code
    • Stopping Code

  • Excel Objects and their hierarchy

    • Workbook
    • Range
    • Cell
    • Worksheet
    • Columns
    • Rows

  • Using the Offset property
  • Using the object browser
WRITING CODE
  • What is a sub procedure
  • What is a function
  • Formatting Objects
  • Cut / Copy / Paste
  • Deleting rows / columns / ranges / cells
  • Using Msgbox
  • Using Variables
    • Variable Types
    • Understanding Variable Scope

  • If... elseif... end if
  • Using With...
  • Using Do... Loop
  • Creating a simple function
    • Understanding VBA's Operators (*, /, + etc)

Excel VBA Level 1

Price on request