Skip to main content

Introduction to VBA Programming

  • 6329 Accesses

Abstract

In the previous chapter, we mentioned that VBA was Excel’s programming language. It turns out that VBA is the programming language for all the Microsoft Office applications. Also VBA is becoming the programming language of other popular applications. Some of the other applications that are using VBA as its programming language are Visio and Business Objects. This is very exciting news for people who automate applications. The main advantage is that a person does not have to constantly learn a new language when he or she deals with a new application. Another important advantage of an application adopting VBA as a programming language is it is a language that uses most of the programming concepts that professional programmers use; therefore, VBA is a powerful language. Now, it is easier for an Excel programmer to do Access VBA programming, Word VBA, or even PowerPoint VBA programming. The finance people would say that there is a return in the investment of time in learning VBA.

Keywords

  • Object model
  • Object browser
  • References
  • Type library
  • Variables
  • Data type
  • Option explicit
  • Object variables
  • Functions
  • If statement
  • For loop
  • For Each
  • While loop
  • Arrays
  • Option base
  • Collections
  • Byte
  • Boolean
  • Integer
  • Long
  • Single
  • Double
  • Currency
  • Decimal
  • Variant
  • String

This is a preview of subscription content, access via your institution.

Buying options

Chapter
USD   29.95
Price excludes VAT (USA)
  • DOI: 10.1007/978-3-319-38867-0_23
  • Chapter length: 42 pages
  • Instant PDF download
  • Readable on all devices
  • Own it forever
  • Exclusive offer for individuals only
  • Tax calculation will be finalised during checkout
eBook
USD   139.00
Price excludes VAT (USA)
  • ISBN: 978-3-319-38867-0
  • Instant PDF download
  • Readable on all devices
  • Own it forever
  • Exclusive offer for individuals only
  • Tax calculation will be finalised during checkout
Softcover Book
USD   179.99
Price excludes VAT (USA)

Bibliography

  • Walkenbach J (2013) Excel 2013 power programming with VBA. Wiley, Hoboken

    Google Scholar 

  • Bullen S (2007) Excel 2007 VBA programmer’s reference. Wiley, Indianapolis

    Google Scholar 

  • Bovey R (2009) Professional excel development. Pearson Education, Boston

    Google Scholar 

Download references

Author information

Authors and Affiliations

Authors

Rights and permissions

Reprints and Permissions

Copyright information

© 2016 Springer International Publishing Switzerland

About this chapter

Cite this chapter

Lee, CF., Lee, J., Chang, JR., Tai, T. (2016). Introduction to VBA Programming. In: Essentials of Excel, Excel VBA, SAS and Minitab for Statistical and Financial Analyses. Springer, Cham. https://doi.org/10.1007/978-3-319-38867-0_23

Download citation