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	Click here to request an alternate date Or call us on 020 313 73958 from 8:00 to 22:00 Monday to Sunday. Weekday Wed, 22-Sep-10 09:30 - 16:30 £200 Evening Wed, 22-Sep-10 and Thu, 23-Sep-10 18:30 - 21:30 £200 Evening Mon, 11-Oct-10 and Tue, 12-Oct-10 18:30 - 21:30 £200 Weekday Wed, 13-Oct-10 09:30 - 16:30 £135 Weekday Wed, 3-Nov-10 09:30 - 16:30 £200 Weekend Sat, 13-Nov-10 10:00 - 16:30 £200 Weekday Fri, 3-Dec-10 09:30 - 16:30 £200 Weekend Sat, 18-Dec-10 10:00 - 16:30 £200 Weekday Thu, 6-Jan-11 09:30 - 16:30 £200 Weekend Sat, 15-Jan-11 10:00 - 16:30 £200 Any One-to-One Tuition Any Date - Fully Customisable 09:30 - 16:30 £400 Levels 1-4 Specials: Click here to request an alternate date Or call us on 020 313 73958 from 8:00 to 22:00 Monday to Sunday. Weekday Mon, 11-Oct-10 - Thu, 14-Oct-10 09:30 - 16:30 £540

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