Advanced Excel VBA Training Course

The Advanced Excel VBA training course is the second level of our Excel VBA training course series. It will teach you the skills to develop better VBA application. You will learn how to use custom-made forms to validate the data entry and improve the end-users experience. Several advanced topics like event programming and debugging techniques are also included which can help you to build a more robust VBA system.

Different practical examples and exercises are used thorough the class and the adoption of small class size approach can ensure the best learning result. Students should complete our Excel VBA course or possess equivalent knowledge of the subject.

What you’ll learn

Working with UserForm

  • Creating a userForm
  • Calling a userForm
  • Hiding a userForm
  • Adding CommandButtons / OptionButtons
  • Adding Event-handler procedure
  • Introducing userForm control types
  • –Text box, button, list box, checkbox, combo box
  • Verifying Field Entry
  • Collect userForm Controls input
  • Filling userForm Controls with user data

Events Programming

  • Disable/Enable Events
  • Events for Worksheet
  • Events for Workbook
  • Events for userForm Controls
  • Events for application
  • Events Not Associated with Objects
  • onTime Event / KeyPress Event

Error Handling Techniques

  • On Error statement
  • Resuming after an error
  • Identifying specific errors

Debugging techniques

  • Using MsgBox functions
  • Using Debug.Print statement
  • Setting breakpoints
  • Using Watch Window
  • Using Locals Window

VBA Speed Tips

  • Turning off screen updating
  • Turning off automatic calculation

SCHEDULES
 
SVB8011 - 廣東話 12 Jan enrol
 
SVB8031 - 廣東話 21 Mar enrol
 
SVB8041 - 廣東話 21 Apr enrol
 
SVB8061 - 廣東話 19 Jun enrol
 
SVB8081 - 廣東話 13 Aug enrol
RELATING COURSES
  Advanced Excel and Excel VBA
  Excel VBA
  Excel-Advanced
  Excel-formulas & functions