Instructor led Courses << Back to Home
kur

Excel VBA 2010 - Advanced Level

Microsoft Excel VBA 2010 Basic at Advanced Level

This two-day course is designed to introduce and explore the capabilities of Visual Basic for Applications within Excel.

Delegates will learn the basics of structured coding and how to utilise simple forms in application development.

Those attending this course should have a good working knowledge of Excel.

  • Delegates should have a strong understanding of Excel
    • Attendeded Basic to Advanced level Excel Courses or
    • Be very experienced in the use of Excel
    • Have a good working knowledge of basic Macros in Excel

    • You do not need
      • Previous experience of programming

    If you would like to discuss this course further or wish to enquire if you're at the correct level call us on 08458 62 62 65 we'll be only too pleased to help.

  • By the end of this course you'll be able to
    • Recognise the differences between VB and VBA, and the benefits of using VBA coding.
    • Take recorded code and using simple VBA techniques, edit, copy and build toggling routines.
    • Recognise the object, method and property nature of the Visual Basic language.
    • Navigate the various elements of the Visual Basic Editor.
    • Name, delete and copy code storage units.
    • Create code using decision making and repeating commands.
    • Create Message boxes to give users information.
    • Create Input boxes to retrieve data during the running of code.
    • Utilise variables to temporarily store data during the running of VBA code.
    • Build dialogue boxes to control data input.
    • Utilise the features within VBA that enable the developer to thoroughly test and debug their coding.
    • Build code segments that deal seamlessly with mistakes that a user of coding might make.
    • Utilise the Online help facility and the Object Browser.
  • Lesson 1 - VB &VBA
      • The difference between VB & VBA
      • VBA coding
    • Lesson 2 - The VB Editor
        • Use simple VBA techniques
        • Edit, copy & build toggling routines
        • Navigate the various elements of the Visual Basic Editor
      • Lesson 3 - The VB Language
          • Object, method & property nature of the Visual Basic language
          • Name, delete & copy code storage units
          • Create code using decision making & repeating commands
          • Create Message boxes to give users information
          • Create Input boxes to retrieve data during the running of code
        • Lesson 4 - Data Input and Storage
            • Utilise variables to temporarily store data
            • Build dialogue boxes to control data input
          • Lesson 5 - Testing and Help
              • Test and debug their coding
              • Deal with user mistakes
              • The Online help facility
              • The Object Browse Facility

Similar Courses