Microsoft^® Excel 2010: Task Automation with VBA Using Macro

This 2-day Microsoft Excel VBA training shows you how to automate tasks by writing Macro. Learning to write Macros in VBA is a time-saving approach while on the other hand helping you to discover the greater potential of Microsoft Excel.

To request for in-house training, click on the Request for In-house Training link as displayed above for quotation. For a complete course cotent and more information about this course, feel free to contact the training provider as shown above. If the public program is available, you can request for a registration online by clicking on the Register for Public Training link. If the link is disabled, it simply means it has yet to be available for public. You can contact the training provider for further inquiry.

Upon completion of this VBA course, you should be able to:

• Create procedures to control the behaviour and appearance of an Excel spreadsheet,
• Create procedures that run in response to specific events
• Create user forms to accept or display data, validate the data entry in user forms, and debug and handle errors in code

Recording a Macro

• Recording a macro
• Running a macro
• Editing a macro

VBA terminology

• Start the VBA editor
• Work with:
  • Object properties
  • Methods
• Attach code to events and buttons
• Use the object browser

Programming basics

• Variables and data types
• Expressions
• Manipulating data
• Getting input from the user in Input and Message boxes
• Variables and scope
• Procedures
• Calling one procedure from another

Using loops

• Do / while
• For / Next

• Microsoft® Excel VBA for Non-Programmers
• Microsoft® Excel VBA Level 2: Developing Macro Applications
• Microsoft® Excel 2013 Basic & Intermediate
• Microsoft® Excel for Intermediate/Advance User
• Maximizing Microsoft® Excel Tools for Fast & Accurate Business Reporting
• More other Information Technology related courses