Excel VBA Level 1

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.

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

Further Details

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 workboko

THE VBA ENVIRONMENT
• The Screen Components

­ Project Explorer
­ Project Properties
­ The Code Window
­ The Immediate Window
­ Finding

THE 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)

This Training Course is taught in classrooms in the following locations:

London SE

Guide Price: £150

Delivery: Classroom
Regions:
  • London
Category: Programming