Award Crest
York College

Programme Content

To teach experienced users of Excel how to automate many kinds of sheet operations in macros. As well as utility macros (Sorting, Printing, Filtering etc.), user defined functions, user input, arrays and event driven macros are also covered.

Topics

  • Recording Macros Absolutely & Relatively
  • VBA Projects, Modules and Procedures - structure and coding
  • Running macros - Keys, Buttons, Events and Menus
  • User Defined Functions
  • Variables and Constants - Declaration, assignment & scope
  • Reading from, and writing to, worksheet cells
  • Objects & Collections - Properties, Methods & Object Browser
  • Handling User input and showing messages
  • Using message boxes to make decisions
  • Flow of Control commands (IF, SELECT, FOR, DO, WHILE etc.)

Day Two

  • Arrays in Excel VBA
  • Calling Excel Dialogue boxes
  • Importing Text Files and calling File, Open and Save as dialogues
  • Creating your own User Forms
  • User Form controls and properties
  • Writing code behind User Forms
  • Debugging Macros, Breaks, Watches & Run Time errors
  • Running Macros from Workbook and Worksheet events

Comments

Designed to help experienced Excel users automate common spreadsheet tasks and create end-user systems.

Delivery and Attendance

This course will take place at York College.

Two day course - 9.30am to 4.30pm.

Next Dates

30th-31st October 2018
16th-17th April 2019

Price

£170.00 per delegate.

Further Information and Booking

If you're interested in this course then please contact us on:

Business Development Unit,
York College,
Sim Balk Lane,
York,
YO23 2BB

Email: This email address is being protected from spambots. You need JavaScript enabled to view it.

Tel: 01904 770368.

Course Enquiry

Please type your full name.
Invalid email address.
Please tell us about your enquiry
  
×