Our Workshops

Visual Basic for Excel

Visual Basic for Excel

Description

3-Day Workshop

CREATE SPECIFIC EXCEL FUNCTIONS TO MATCH YOUR NEEDS

 Modify and manipulate spreadsheets easily and effortlessly
Visual Basic for Excel offers delegates a comprehensive understanding of the enhanced capabilities of Excel when using Visual Basic to modify and manipulate spreadsheets. Overall, the workshop gives participants the confidence to use Visual Basic within the Excel environment, and includes instruction in the creation of customised functions.

Practical learning session with templates and exercises
During the 3-day workshop, ample time will be devoted to practical exercises that allow delegates to practice and further anchor the learned skills. Aimed at further enhancing your knowledge of Excel for the purposes of advanced functionality, this intensive 3-day workshop enables you to utilise normally uncharted territory in the one of Microsoft’s most powerful Office Suite offerings.

Workshop Outline

The Excel Window Components     

The Visual Basic Editor Window Components           

Introduction to Macros and VBA       

Record a macro/ Edit a Macro  

Break code onto a new line   

Open the Visual Basic Editor 

Visual Basic Editor Window Components  

Add a Module sheet in the VB Editor

Rename the Module Sheet    

Delete a Macro / Create a Macro Button/ Edit a Macro Button  

Create a Custom Toolbar Button / Change the Button Settings   

Attaching a Toolbar / Adjust Macro Settings

Create Digital Signatures / Apply Digital Signatures        

Add Project Properties / Lock the Project for Viewing     

The Range Object and Selection Techniques         

Range Object – Cells / Practice – Cell Selection / Stepping through the Code    

Range Object – Range / Practice – Range Selection / Range – Offset and Resize / Practice - Offset and Resize / Access Range Contents           

Objects, Properties and Methods   

Using Help to learn about Objects / Use the Object Browser to learn about Objects       

Range – Selection and Activate / Practice – Select and Activate / Practice – Properties / Practice – Multiple Properties with With      

Variables       

Option Explicit / Data Types / Practice – Arrays / Practice – Dynamic Arrays    

More Range Properties        

Row and Column / Practice - Row and Column Properties         

End and Virtual Ranges / Practice End Selection / Cell Addresses / Practice Cell Address / A Better Address Exercise     

Workbooks and Sheets        

Switching Between Workbooks / Activate Exercise / Insert Worksheets / Copy and Rename Sheets / Printing Sheets           

Variables Scope and Constants       

Practice - Variable Scope / Constants       

Conditional Control Structures      

Practise If / Practice - Select Case

Day 3 Practical

Creating the form’s interface

Preparing the Form’s functionality

Implement the Form

______________________________________________________________________________________________________________________________________________________________

On-Site Workshops

  • All workshops are offered in-house at your offices to a minimum of 5 delegates
  • You provide the venue and refreshments, Front Foot supply all the workshop material – including laptops for computer-based training sessions

Remote Workshops

  • All workshops are offered remotely to a minimum of 5 delegates
  • Front Foot supply all the electronic workshop material

________________________________________________________________________________________________________________________________________________________________

 

Workshop Dates