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
________________________________________________________________________________________________________________________________________________________________