Getting Started
• Displaying the Developer Tab
• Recording and running a Macro
• Macro-Enabled Workbooks
• Using the Visual Basic Editor
• The Development Environment
• Understanding Macro Security
Working with Procedures and Functions
• Understanding Modules
• Understanding Procedures
• Calling Procedures
• Creating a Function Procedure
• Working with the Code Editor
Understanding Objects
• Objects and Collections
• Working with Properties
• Using the With Statement
• Creating an Event Procedure
Using Expressions, Variables, and Intrinsic Functions
• Understanding Expressions and Statements
• Declaring Variables
• Understanding Data Types
• Using Intrinsic Functions
• Understanding Constants
• Declaring and using Object Variables
Controlling Program Execution
• Control-of-Flow Structures
• Working with Boolean Expressions
• Different types of Control-of-Flow structures
• Guidelines for use of Control-of-Flow Structures
Working with Forms and Controls
• Working with UserForm Properties, Events and Methods
• Working with different Controls
• SettingControl Appearance
• Populating a Control
• Adding Code to Controls
• Launching a Form in Code
Handling Errors
• Understanding Error Handling
• Writing an Error-Handling Routine
• Working with Inline Error Handling
Questions and answers
| Course Dates | Venue | Price | ||
|---|---|---|---|---|
| London Bridge | £449 + VAT | |||
| Online | £449 + VAT | |||
| London Bridge | £449 + VAT | |||
| Online | £349 + VAT save £100 | |||
| London Bridge | £449 + VAT | |||
| Online | £349 + VAT save £100 | |||
| London Bridge | £449 + VAT | |||
| Online | £449 + VAT | |||
| London Bridge | £449 + VAT | |||
| Online | £449 + VAT | |||
| London Bridge | £449 + VAT | |||
| Online | £449 + VAT | |||
| London Bridge | £449 + VAT | |||
| Online | £449 + VAT | |||
| London Bridge | £449 + VAT | |||
| Online | £449 + VAT | |||
| London Bridge | £449 + VAT | |||
| Online | £449 + VAT |
Tom works in Internal Communications for an NHS service provider. Listen to his experience about attending our online Adobe Premiere Intro course.
Meija works for the MOD, in marketing and communications and here tells us about attending her online Social Media Marketing course with Alice.
Katie works for the Ministry of Defence as a Digital Content Editor and here tells us about attending her online Social Media Marketing course with Kirsty.
"Answering Questions to all Excel Questions not just questions relevant to the course. Also answering questions on other systems which have Excel working behind the scenes such as Power BI"
