Find & Book a Course

To see course calendar, click here

OnLine courses

We are pleased to offer our new online course 'Tracing your Irish Ancestors'. If you are already registered for this course, please login to our Online Course module.

Online Business Account

Your business frequently books courses with Irish Times Training?
Find out if you are eligible for an online business account
Course Duration

1 day(s)

Course Fee

€400
(includes course material, lunch and light refreshments)

Course Schedule

No course schedule now

Course Location

The Irish Times Building, 24 - 28 Tara Street, Dublin 2

This course can also be offered on a tailored in-company basis.

This 1 day course has been specially designed for advanced user who wants to make use of the more powerful facilities of MS Excel made available by VBA. This course explores VBA language and delegates will be encouraged to write programs to ensure that future editing, amending and updating can be carried out with the minimum of effort.

 
Course Outline
 
  • Introduction
  • Assigning Macros to Buttons and Objects
  • Editing Macros
  • The Range Object
  • Workbooks and Sheets
  • Objects, Properties and Methods
  • Variables and Constants
  • Control Structures
  • Controls and Dialogue Boxes
  • Storing Information
  • Debugging and Error Trapping
  • Worksheet and Workbook Events
  • Function Procedures
 

MS Excel VBA

 
Share |