Find out if you are eligible for an online business account
- - Occupational First Aid
- - Dreamweaver - Web Design Level 1
- - Finance For Non-Financial Managers
- - Assertiveness Skills
- - Introduction to Internet & Email
- - Minute Taking
- - Certified Internet Recruiter (CIR)
- - Debt Collection / Credit Control
- - Certified Social Media Recruiter (CSMR)
- - Managing People
MS Excel VBA
Course Duration1 day(s) |
Course Schedule
No course schedule now Course LocationThe 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
Location: Irish Times Training, The Irish Times Building, 24 - 28 Tara Street, Dublin 2
Email a friend:
| Your Email: | |
| Your Friends Email: | |
| Message (Optional): | |
