Find Courses Find Providers Providers - Promote Your Courses About Us

Excel VBA (2-days)

Training Courses

Would you like to see more Microsoft Excel courses?

Training course summary

Sponsored links

Objectives: After completing this course, you will know how to: Use Visual Basic for Applications terminology, start Visual Basic Editor, and work with object properties, methods, and events. Manipulate data by declaring variables and procedures of correct scope to be used when and where you need them. Use decision structures to perform decision tasks and loop structures to perform repetitive tasks. Add a user form to your project, add controls on it, handle events associate with form controls, and validate data entry on forms. Identify errors in code, use the debugging tools, and write error-handling code to trap errors. Prerequisites: This is a generic course and is suitable for users of any version of Microsoft Excel VBA Target Audience: Anyone wishing to automate common worksheet operations, convert worksheets into forms and understand Excel VBA code.
Regions:
  • All Areas
Delivery:
  • In House
  • Public
  • Computer Based
Category:
Difficulty:
  • Introductory

Further Details

Course Content: Visual Basic For Applications Overview The VBA Editor Program Structure Customising The VBA environment Recording and Running Procedures Naming and Recording Procedures Controlling Reference Type Assigning Procedures Viewing and Editing Procedures Reading Visual Basic Code Editing Visual Basic Code VBA Project Properties Working with Visual Basic Code Variables Sub Procedures User Defined Functions Objects, Properties and Collections Controlling Objects using Properties Performing actions with Methods Object Collections and Variables User Input, Control and Looping User Input Control Structures Looping Debugging and Error Handling Compile Errors Run-time Errors Logical Errors Debugging Code Customising the User Interface Worksheet Forms Custom Dialog Boxes

Guide price

£550 per person (public course)

 

Sponsored links

Interested in this course?

 

 
Information provided is for information purposes only and no guarantees are made with regards to accuracy. It is advised that all details are checked prior to making a booking. Terms of use
Website design by Brit-net