Chapter 2. Fundamentals of Programming with VBA

  1. E. Joseph Billo

Published Online: 2 NOV 2006

DOI: 10.1002/9780470126714.ch2

Book Title

Excel for Scientists and Engineers: Numerical Methods

Excel for Scientists and Engineers: Numerical Methods

Additional Information

How to Cite

Billo, E. J. (2006) Fundamentals of Programming with VBA, in Excel for Scientists and Engineers: Numerical Methods, John Wiley & Sons, Inc., Hoboken, NJ, USA. doi: 10.1002/9780470126714.ch2

Publication History

  1. Published Online: 2 NOV 2006
  2. Published Print: 23 MAR 2007

ISBN Information

Print ISBN: 9780471387343

Online ISBN: 9780470126714

SEARCH

CHAPTER TOOLS

Get PDF (3549K)

Keywords:

  • progam control;
  • logical operators;
  • looping;
  • Visual Basic arrays;
  • ParamArray keyword

Summary

This chapter contains sections titled:

  • Components of Visual Basic Statements

  • Program Control

  • VBA Data Types

  • Subroutines

  • VBA Code for Command Macros

  • Making a Reference to a Cell or a Range

  • Interacting with the User

  • Visual Basic Arrays

  • Custom Functions

  • Arrays in Function Procedures

  • Creating Add-In Function Macros

  • Testing and Debugging

Get PDF (3549K)