Advanced Visual Basic for Excel
Need course dates or locations to suit you? CLICK HERE TO SEND ENQUIRY...  
This Advanced Visual Basic for Excel training course is held in London in the South East, Birmingham in the Midlands, Bristol in the South West, Leeds and Manchester in the North and Edinburgh in Scotland. Please select the Course Dates Tab above to see current course dates, or select a category link above to see more course and location options. Advanced Visual Basic for Excel.

About the Course:
A step up from our introductory course, this day takes you through advanced methods of data management and smart uses of VBA programmes.

Course Overview:
- Macros: Debugging and Tracing Errors in Macros Visual Basic Objects Range
- Object Flexibility and Constraints
- Object Hierarchy Workbooks and Worksheets
- Activating Worksheets and Workbooks through VBA Constants and Variables Structure
- Control and Conditional Structure
- Control Sub-Routines and Non-Structured Information
- Customising Forms and Dialogue Boxes
- Using Forms with Pre-Defined Dialogue Boxes
- Form Controls and Properties; Customised Forms
- Adding in Other Applications
- What are Add-Ins?
- Generating an Add-In
- Using Add-Ins in a Workbook
- Error Handling within the Programme Logic

 
Need course dates or locations to suit you? CLICK HERE TO SEND ENQUIRY...  
My Location
Results for location are highlighted in the table below. Click here to remove highlight
The course either has new dates in data loading, or is only run as a dedicated or In Company course.
Tools
 
Key Details
Duration1 day
 
£275
per delegate
 
 
Bookings Helpline: 01933 233884 (Monday to Thursday - 8:00am to 5:30pm and Friday 8:00am to 5:00pm).