17. Programming with VBA

  1. E. Joseph Billo

Published Online: 1 NOV 2011

DOI: 10.1002/9781118093955.ch17

Excel for Chemists®: A Comprehensive Guide, Third Edition

Excel for Chemists®: A Comprehensive Guide, Third Edition

How to Cite

Billo, E. J. (2011) Programming with VBA, in Excel for Chemists®: A Comprehensive Guide, Third Edition, John Wiley & Sons, Inc., Hoboken, NJ, USA. doi: 10.1002/9781118093955.ch17

Publication History

  1. Published Online: 1 NOV 2011
  2. Published Print: 16 SEP 2011

ISBN Information

Print ISBN: 9780470381236

Online ISBN: 9781118093955

SEARCH

Keywords:

  • VBA;
  • visual basic code;
  • variables;
  • arguments;
  • range object

Summary

This chapter contains sections titled:

  • Creating Visual Basic Code

  • Objects, Properties and Methods

  • Objects

  • Making a Reference to a Cell or a Range

  • Tutorial on Ways to Refer to a Cell or Range

  • Properties

  • Methods

  • VBA Functions

  • VBA Commands

  • VBA Data Types

  • Program Control

  • Looping

  • Subroutines

  • Interactive Macros

  • Using Excel 4 Macro Commands

  • Testing and Debugging

  • To Step Through VBA Code

  • Using VBA On-Line Help

  • Some Ways to Improve the Performance (i.e., Speed) of Your VBA Procedures