Top navigation bar Bottom navigation bar

Leisure courses

Access courses

Part-time course already started?

We are currently reviewing our courses to determine how we can adapt them during the pandemic to ensure we provide an outstanding student experience. Register you interest to be the first to apply for this course in July!

» I'm interested in courses at Bedford College

» I'm interested in courses at Shuttleworth College

Microsoft Excel: Advanced Programming Using VBA

Builds upon the current knowledge of programming Microsoft Excel using Visual Basic for Applications (VBA) by learning how to extend the functionality and usefulness of Microsoft Excel through added capabilities that are available only through VBA. It builds on knowledge from the Introductory course in Programming Microsoft Excel using VBA by extending knowledge to programming functionality using the Visual Basic Editor.

Entry requirements

Successful completion of the course Introduction to Programming Microsoft Excel using Visual Basic for Applications (VBA), or a good knowledge of creating Macros in Microsoft Excel and using the Microsoft Visual Basic Editor.

Course content

This course will allow you to:

  • Use the For loop to repeat the execution of code
  • Create code that allows users to respond to prompts such as the input box and the message box
  • Identify, select and manipulate worksheet cells more effectively by using appropriate objects, methods and properties

Assessment methods

Completed assignments.

Course Information & How to Apply

Unfortunately this course has been cancelled. Please ring 01234 291000 or email enquiries@bedford.ac.uk for alternatives.

LengthStart DateDay(s)Time(s)FeesLocationCourse Code
1 day 18/05/2015 Mon 9.30 am - 4.30 pm £150 Cauldwell Street F2143 Course in progress

 

Additional Learning Support
If you have a specific learning difficulty or disability, are deaf or hearing impaired, our Additional Learning Support team are on hand to give you assistance whenever you need it.  Find out more.

Autism & Asperger’s Syndrome Support
At Bedford College, we are committed to developing the provision for students on the autistic spectrum, including Asperger’s Syndrome.  Find out more.

Accessibility
We have access arrangements in place to help students with disabilities or any other particular needs. Call us on 01234 291000 for more information.

Additional formats
Course information sheets are also available in large print and audio formats. Call us on
01234 291000 to order your copy.
YouTube Instagram LinkedIn Moodle Higher Education Moodle Have Your Say