£700 per delegate. This may be less for special offers on specific course dates and in-company training courses
Duration: 2 days
Trainer: S047OW
Need course dates or locations to suit you? CLICK HERE TO SEND ENQUIRY...
Introduction
Course Contents
Recording macros and buttons
- Absolute and relative recording
- Where macros can be stored
- Assigning macros to buttons
Selecting cells
- Selecting cells (absolute)
- Selecting cells (relative)
- Selecting to the end of a block
- Selecting a range by its corners
The VB code editor
- Using Project Explorer
- Creating modules
- Basic subroutines and comments
Messages and variables
- Input boxes and message boxes
- Declaring variables
- Option Explicit
- Scope of variables
- Constants
Visual Basic explained
- The Excel object model
- Objects and collections
- Methods and properties
- Getting help in VBA
Loops and conditions
- Simple IF conditions
- Multiple IF and SELECT / CASE
- Three main types of loop
- Object variables
- Looping over collections
Event handling
- Assigning macros to events
- Cancelling events
Functions
- Declaring functions
- Passing arguments
Debugging and error handling
- Setting breakpoints
- Stepping through macros
- ON ERROR statements
Forms
- Drawing forms
- Attaching macros to controls
- Validating form input
Referencing other applications (*)
- Links to Word or Access
- Working with files and folders
Tired of repeating tasks in Excel? Perhaps it's time to automate your work, by learning how to write macros using the built-in VBA programming language (VBA stands for Visual Basic for Applications, and is the language also used by Access, Word, Outlook and PowerPoint).
Prerequisites
Delegates should be comfortable with using Excel (no advanced knowledge is needed). No experience of progamming is needed, although delegates should enjoy the logical challenge of learning new computer systems.
Course Contents
Recording macros and buttons
- Absolute and relative recording
- Where macros can be stored
- Assigning macros to buttons
Selecting cells
- Selecting cells (absolute)
- Selecting cells (relative)
- Selecting to the end of a block
- Selecting a range by its corners
The VB code editor
- Using Project Explorer
- Creating modules
- Basic subroutines and comments
Messages and variables
- Input boxes and message boxes
- Declaring variables
- Option Explicit
- Scope of variables
- Constants
Visual Basic explained
- The Excel object model
- Objects and collections
- Methods and properties
- Getting help in VBA
Loops and conditions
- Simple IF conditions
- Multiple IF and SELECT / CASE
- Three main types of loop
- Object variables
- Looping over collections
Event handling
- Assigning macros to events
- Cancelling events
Functions
- Declaring functions
- Passing arguments
Debugging and error handling
- Setting breakpoints
- Stepping through macros
- ON ERROR statements
Forms
- Drawing forms
- Attaching macros to controls
- Validating form input
Referencing other applications (*)
- Links to Word or Access
- Working with files and folders
Please note that any items marked with a * will be covered if time allows.
Course Times
Usually 9.30am - 4.30pm. Course times will be confirmed in the joining instructions once the course has been booked.
The course either has new dates in data loading, or is only run as a dedicated or In Company course.
Telephone Hotline
01933 233884
(Monday to Friday - 8:00am to 5:30pm).
© 2021 Book My Course Limited. All rights reserved
Home | About Us | Contact Us | FAQs | Privacy Policy | Terms & Conditions | Site Map | News / Articles | Cookie Policy