Visual Basic for Applications

Visual Basic for Applications (VBA) is an implementation of Microsoft's event-driven programming language, Visual Basic 6, and its associated integrated development environment (IDE). VBA is built into most Microsoft Office applications, including Office for Mac and other applications such as Microsoft MapPoint and Microsoft Visio.[1]

This course is comprised of 15 lessons on the use of Visual Basic for Applications in Microsoft Office. Primary focus is on using VBA in Excel, but there are also lessons on VBA in Word, PowerPoint, Outlook, and Access. Each lesson includes a combination of Wikipedia and Microsoft readings, YouTube videos, and hands-on learning activities.

Preparation

This is a third-semester, college-level course. Learners should already be familiar with introductory computer concepts and have advanced or proficient-level computer skills.

Lessons

  1. 75% Recording Macros
  2. 75% Editing Macros
  3. 75% Variables
  4. 75% Expressions
  5. 75% Conditions
  6. 75% Loops
  7. 75% Arrays
  8. 75% Errors
  9. 75% Procedures
  10. 75% Classes
  11. 75% Word
  12. 75% Excel
  13. 75% PowerPoint
  14. 75% Outlook
  15. 75% Access

See Also

References

  1. ↑ Wikipedia: Visual Basic for Applications
This article is issued from Wikiversity - version of the Saturday, November 28, 2015. The text is available under the Creative Commons Attribution/Share Alike but additional terms may apply for the media files.