| Appraisal Skills |
| Assertiveness for Managers |
| Basic Employment Law |
| Change Management |
| Coaching for Performance |
| Equality and Diversity |
| Facilitating Effective Meetings |
| Finance for Non-Financial Managers |
| Recruitment and Selection |
| Stress Management |
| Supervisory Management |
| The Middle Managers Toolkit |
| Time Management for Managers |
| Access |
| AutoCAD Intermediate |
| AutoCAD Introduction |
| Crystal Reports |
| Excel |
| Lotus Notes |
| Microsoft Office Upgrade Courses |
| Outlook Advanced |
| Outlook Introduction |
| PC Awareness - Level 1 |
| PC Awareness - Level 2 |
| Powerpoint |
| Project Advanced |
| Project Introduction |
| Publisher |
| Sageline Accounts |
| Sageline Payroll |
| SharePoint Administration |
| Sharepoint End-User |
| VBA |
| Visio Advanced |
| Visio Introduction |
| Word |
| A+ |
| Active Directory |
| Configuring Windows Server 2008 Active Directory |
| Exchange 2000/2003 Administration |
| Exchange 2007 |
| Exchange 2010 |
| Introduction to PC Technology |
| MCDST |
| Microsoft Exchange Server 2010 |
| Network + |
| Oracle Database 10g: Administration |
| SQL 2005 |
| SQL 2008 |
| TCP/IP |
| Windows 7 |
| Windows 7 Enterprise Desktop Support Technician |
| Windows Desktop Support Skills |
| Windows SBS |
| Windows Server 2003 MCP |
| Windows Server 2008 Administration |
| Windows Server 2008 New Features |
| WLAN Networking |
| ITIL® Foundation V3 |
| PRINCE2® Combined Foundation and Practitioner |
| PRINCE2® Foundation |
| PRINCE2® Overview |
| PRINCE2® to Practical |
| Advanced Presentation Skills |
| Assertiveness |
| Business & Letter Writing |
| Cold Calling |
| Communication Skills |
| Creating Sales People that Sell! |
| Customer Care |
| Dealing with Aggressive Callers |
| Introduction to Marketing |
| Managing the Anger Habit |
| Minutes & Note-Taking |
| NLP |
| Participating Effectively in Meetings |
| Persuasive Selling |
| Presentation Skills |
| Presentation Skills for Sales People |
| Report Writing |
| Sales Skills and Strategy |
| Telephone Techniques |
| The Effective Receptionist |
| The Executive Secretary |
| The Training Administrator |
| Time Management |
| Train the Trainer |
| Requirements for Electrical Installations 3-days |
| Requirements for Electrical Installations 5-days |
| Working at Height |
Macros VBA
Duration 2 days
Course Content
Simple Macros
Recording a Macro
Running a Macro
Using the Visual Basic Toolbar
Making Macros Easier to Use
Adding to the Tools Menu
Assigning to a Button on a Sheet
Assigning to a Toolbar Button
Assigning to a Graphic Object
Macro Storage
Relative & Absolute References
Viewing & Modifying Visual Basic Code
Module Sheets
Reading Visual Basic Code
Statements
Comments
Rem Statements
Keywords
Keystrokes used in a Module Sheet
Editing Code
Deleting Unnecessary Code
Making Long Statements Readable
Customising Code
Making a Macro Interactive
Recording Code into an Existing Macro
Making Macros Make Decisions
Control Structures (Decision Making)
If...Then
If...Then...Else
Control Structures (Looping)
Do Loop
Objects
Object Properties
Common Properties
Object Methods
Toggling the Property of an Object
On-Sheet Controls
Placing Controls on the Worksheet
Setting the Properties of a Control
Linking Controls to Worksheets
Very knowledgeable, not stumped by any questions and flexible to diverge
Created friendly working atmosphere, very knowledgeable
All round excellence
Excellent, we got through everything that I particularly needed to know about, very well planned and executed tuition
Very good. Worked closely with me so that I gained all the knowledge I needed from the course.
Ivan (the trainer) showed great ability to deal with a wide range of queries and always did the little bit extra to make sure we learnt all we needed to.