Visual Basic for Applications

From Everything Wiki
Jump to navigation Jump to search
0.00
(0 votes)

{{#invoke:Sidebar|sidebar}} 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 comprises 16 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[edit]

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[edit]

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

See Also[edit]

Bibliography[edit]

  • Alexander, M. and Kusleika, D. (2019). Excel 2019 Power Programming with VBA. Wiley. ISBN 9781119514916{{#invoke:check isxn|check_isbn|9781119514916|error= Invalid ISBN}}
  • Alexander, M. and Walkenbach, J. (2018). Excel VBA Programming For Dummies. Wiley. ISBN 9781119518242{{#invoke:check isxn|check_isbn| 9781119518242|error= Invalid ISBN}}
  • Mansfield, R. (2013). Mastering VBA for Office 2013. Wiley. ISBN 978-1-118-69512-8{{#invoke:check isxn|check_isbn|978-1-118-69512-8|error= Invalid ISBN}}

References[edit]

Template:CourseCat

Template:Tertiary


You are not allowed to post comments.