What you’ll learn

Working with Arrays

• Declaring arrays
• Declaring multidimensional arrays
• Declaring dynamic arrays

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

Working with Microsoft Access

• Understanding Access Object Model and Key Object
• Establishing ADODB connection
• Creating Recordset
• Importing data from Access file
• Adding, updating, removing records in Access tables