Skip to main content
SpringerLink
Log in

Introduction to VBA Programming

  • Chapter
  • First Online:
Book cover Essentials of Excel, Excel VBA, SAS and Minitab for Statistical and Financial Analyses

  • 6831 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.

This is a preview of subscription content, log in via an institution to check access.

Access this chapter

Log in via an institution
Chapter
USD 29.95
Price excludes VAT (USA)
  • Available as PDF
  • Read on any device
  • Instant download
  • Own it forever
eBook
USD 139.00
Price excludes VAT (USA)
  • Available as EPUB and PDF
  • Read on any device
  • Instant download
  • Own it forever
Softcover Book
USD 179.99
Price excludes VAT (USA)
  • Compact, lightweight edition
  • Dispatched in 3 to 5 business days
  • Free shipping worldwide - see info

Tax calculation will be finalised at checkout

Purchases are for personal use only

Institutional subscriptions

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

  1. Department of Finance, Rutgers University, Piscataway Township, NJ, USA

    Cheng-Few Lee

  2. Center for PBBEF Research, Morris Plains, NJ, USA

    John Lee

  3. Department of Quantitative Finance, National Tsing Hua University, Hsinchu, Taiwan

    Jow-Ran Chang

  4. Mezocliq, LLC, New York, NY, USA

    Tzu Tai

Authors
  1. Cheng-Few Lee
    View author publications

    You can also search for this author in PubMed Google Scholar

  2. John Lee
    View author publications

    You can also search for this author in PubMed Google Scholar

  3. Jow-Ran Chang
    View author publications

    You can also search for this author in PubMed Google Scholar

  4. Tzu Tai
    View author publications

    You can also search for this author in PubMed Google Scholar

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

Publish with us

Policies and ethics

Search

Navigation