Course

In Southwark

Price on request

Description

  • Type

    Course

  • Location

    Southwark

  • Duration

    1 Day

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

Important information

Government funding available

Facilities

Location

Start date

Southwark (London)
See map
202 Blackfriars Road, SE1 8NJ

Start date

On request

About this course

Must least have had sufficient
exposure to the concepts covered in Level 1 to be able to move
onto new concepts.

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
Must least have had sufficient exposure to the concepts covered in Level 1 to be able to move onto new concepts.


Revision of Level 1
  • VBE Components
  • If Statements

  • With...

Continuing Sub Procedures
  • Revisiting the scope of Variables

    • Dim
    • Public dim
    • Const
    • Public const

  • Understanding Events

  • User Input

    • A simple form
    • Inputbox and Msgbox
    • Using Worksheet Data
    • Providing a browse for a file box
    • Providing a GetSaveAsFileName box to save a file

  • Using Select Case vs using If statement

  • Expanding on Conditional Formatting limitations

Looping
  • For Each cell in range... etc

  • Do While... Loop

  • Do Until... Loop
  • For a = 1 to 50 etc
Error Handling
  • Setting and going to Bookmarks
  • Catching Errors

  • On error goto....

  • On Error Resume Next

  • On Error goto 0

Functions
  • Using Built in VBA Functions

    • Working out differences in dates (Datediff, etc)
    • Extracting info from a long string (trim, left, right, mid, instr)
    • Working out what kind of value is residing in a cell (isnumeric, isstring, isdate... etc)

  • Creating your own Functions

    • A value with VAT added to it
    • Returning a country based on a provided city
    • Returning the last cell address in a range
    • Returning the last row in a range
    • Returning the last column in a range

Excel VBA Level 2

Price on request