Excel VBA Level 3
Course Outline

DURATION	1 Day
PREREQUISITES	Must be confident or at least have had sufficient exposure to the concepts covered in Levels 1 and 2.
DESCRIPTION	Anyone wishing to automate common worksheet operations, convert worksheets into forms and understand Excel VBA code.
COURSE DATES	Special: Four Days of MS Office training for the price of Three! Click here to request an alternate date Or call us on 020 313 73958 from 8:00 to 22:00 Monday to Sunday. Evening Wed, 8-Feb-12 and Thu, 9-Feb-12 18:30 - 21:30 £200.00 +VAT Weekday Fri, 24-Feb-12 09:30 - 16:30 £200.00 +VAT Weekend Sat, 10-Mar-12 10:00 - 16:30 £200.00 +VAT Weekday Mon, 26-Mar-12 09:30 - 16:30 £200.00 +VAT Evening Mon, 9-Apr-12 and Tue, 10-Apr-12 18:30 - 21:30 £200.00 +VAT Weekday Wed, 25-Apr-12 09:30 - 16:30 £200.00 +VAT Evening Wed, 9-May-12 and Thu, 10-May-12 18:30 - 21:30 £200.00 +VAT Weekday Thu, 24-May-12 09:30 - 16:30 £200.00 +VAT Weekend Sat, 9-Jun-12 10:00 - 16:30 £200.00 +VAT Weekday Tue, 26-Jun-12 09:30 - 16:30 £200.00 +VAT Evening Mon, 9-Jul-12 and Tue, 10-Jul-12 18:30 - 21:30 £200.00 +VAT Weekday Wed, 25-Jul-12 09:30 - 16:30 £200.00 +VAT Evening Wed, 8-Aug-12 and Thu, 9-Aug-12 18:30 - 21:30 £200.00 +VAT Weekday Fri, 24-Aug-12 09:30 - 16:30 £200.00 +VAT Weekday Wed, 5-Sep-12 09:30 - 16:30 £200.00 +VAT Weekend Sat, 8-Sep-12 10:00 - 16:30 £200.00 +VAT Evening Mon, 8-Oct-12 and Tue, 9-Oct-12 18:30 - 21:30 £200.00 +VAT Weekday Wed, 24-Oct-12 09:30 - 16:30 £200.00 +VAT Weekend Sat, 10-Nov-12 10:00 - 16:30 £200.00 +VAT Weekday Mon, 26-Nov-12 09:30 - 16:30 £200.00 +VAT Weekend Sat, 8-Dec-12 10:00 - 16:30 £200.00 +VAT Weekday Wed, 26-Dec-12 09:30 - 16:30 £200.00 +VAT Any One-to-One Tuition Any Date - Fully Customisable 09:30 - 16:30 £400.00 +VAT Alternatively, use our BOOKINGS FORM for an alternative payment method, or for multiple dates/courses.

Revision of Level 2

Speeding up your macros

• Turning off screen updating
  

• Using the status bar to tell the user about your progress

• Turning off automatic calculation

• Turning off Alert Messages

• Simplifying Object References

• Declaring your variable types

• Using the with-end with structure

Forms

• Showing and hiding

• Designing
  

•  Using option buttons

• Using check boxes

• Using multi pages

• Using other controls

• Showing / hiding options

• Adding pictures

• Ref Edit (so a user can select a range on a sheet)

• Using a spin button

 

• Setting the tab order

• Adding OK and Cancel buttons

• Controlling data entered into a form

• Understanding Events

• Assigning selections to variables

• Unloading

• Using a form as a progress indicator

Useful features

• Using the status bar as a Progress Indicator

• Password protecting your VBA code

Creating a Toolbar

• Manually
  

  • Adding in useful built-in buttons

  • Adding buttons for macros

  • Customising the button

  • Attaching a toolbar to a workbook

   

• Using VBA
  

  • Why?

  • Creating / deleting a toolbar

  • Showing the toolbar

  • Placing the toolbar

  • Adding Buttons

  • Customising the buttons

  • Resetting all in-built toolbars

  • Preventing any design changes to your toolbar

Creating a Menu using VBA

• Creating / deleting a menu

• Placing the menu

• Adding Buttons

• Customising the buttons

• Resetting in-built menu
  

Working with Shortcut menus

• Adding / Deleting menu items to a shortcut menu

• Disabling a shortcut menu

• Resetting a shortcut menu