Get in Touch
 Duration 14 hours

Course Outline

Facilities

  • Designing custom toolbars and menus

Data types

  • Converting to different types
  • Variable scope and lifetime
  • Operators and precedence
  • Options modules

Conditional statements

  • Select Case
  • If ... Then ... ElseIf ... Else

Loops

  • Reversing loops
  • For Each loop
  • Loop break (exit) instructions

Debugging

  • Step-through processing
  • Breakpoints and Watches
  • Locals Window
  • Immediate Window
  • Call Stack

Error handling

  • Capturing and managing run-time errors
  • Structures: On Error Resume Next, On Error GoTo label, On Error GoTo 0
  • Displaying data on the status bar

Basic optimisation

  • ScreenUpdating
  • Measuring macro duration using the Timer method

VBA Forms

  • Creating custom forms
  • Invoking forms from code
  • Utilising forms within spreadsheets

Requirements

None.

Custom Corporate Training

Training solutions designed exclusively for businesses.

  • Customised Content: We adapt the syllabus and practical exercises to the real goals and needs of your project.
  • Flexible Schedule: Dates and times adapted to your team's agenda.
  • Format: Online (live), In-company (at your offices), or Hybrid.
Investment

Price per private group, online live training, starting from £3200 + VAT*

Contact us for an exact quote and to hear our latest promotions

Testimonials (1)

Provisional Upcoming Courses (Contact Us For More Information)

Related Categories