Excel Macros & VBA
Training
In London
Description
-
Type
Training
-
Location
London
-
Duration
2 Days
To give users an understanding of macros and visual basic. Knowledge gained from the problem solving and error trapping exercises will enable delegates to code programmes within the Excel application. Suitable for: This course is suitable for users of Excel who want to gain a good knowledge of VBA and Macros.
Facilities
Location
Start date
Start date
About this course
An advanced knowledge of Excel is required, gained either by previous experience or attendance on the Excel Advanced/Expert course
Reviews
Course programme
Excel Macros (VBA)
Objective: To give users an understanding of macros and visual basic. Knowledge gained from the problem solving and error trapping exercises will enable delegates to code programmes within the Excel application.
Delegates: Maximum 8
This course is suitable for users of Excel who want to gain a good knowledge of VBA. An advanced knowledge of Excel is required, gained either by previous experience or attendance on the Excel advanced course
Delegate numbers are restricted to 8, to ensure personal attention from the trainer
Structure: PC for every delegate
All pass training courses involve extensive hands-on activity including exercises that give participants practical experience of using Excel’s tools.
Duration: 2 days 9.30 am – 4.30 pm
Course Content:
Understanding Macros
Storing Macros
This Workbook
Personal Macro Workbook
New Workbook
Recording a Basic Macro
To record a macro
Relative References
To set the reference type
Running a Macro
To run a macro automatically when you open a file
Invoking Macros
Macros can be invoked (run) from a number places:
To run a macro from the keyboard
To run a macro from the menu
Editing and Deleting Macros
To edit a macro
To delete a macro
Assigning a Macro to a Toolbar or Menu
To assign a macro to a menu or toolbar
Button Image Editor
To edit a button image
To display the button image
Macro Virus Protection
To change the security levels
The Visual Basic Editor Window
Visual Basic Editor layout
Standard toolbar
Object box
Procedure box
Project explorer
Properties window
The Visual Basic Editor
Procedures
Function procedures
Object oriented programming (OOP)
Objects
Properties
Methods
Variables
Data types
List of data types
Expressions
Operators
Constants
Functions
Arguments
Declaring Variables
Dim statement
Private statement
Public statement
Static statement
Option explicit
Working with Objects
Property values
Visual Basic properties
Returning a property value
Object methods
Other common methods
Using operators in expressions
Concatenation (&)
Logical operators
The is operator
The like operator
User defined functions
User interaction dialogue boxes
InputBox function
MsgBox statement
Program flow commands
Decision making commands
Repeat (looping) commands
- The If… Then
- The If…Then… Else… End If structure
- The nested If structure
- The select case… End select structure
- The Do… While loop
- The Do… Until loop
- The For… Next loop
- Handling run time errors
- User forms (custom dialogue boxes)
- Adding controls to a custom dialogue box
- Practical usage of Macros
STAGE 1 setting up the spreadsheet
STAGE 2 setting up the input area
STAGE 3 writing the macro to accept data entry
STAGE 4 Transferring the input to the spreadsheet
STAGE 5 Error Trapping
Dealing with dates
Dialogue boxes
Price: £375 + VAT per delegate
Additional information
Payment options: All Courses can be held privately at our premises or otherwise.
Excel Macros & VBA