19. Command Macros

  1. E. Joseph Billo

Published Online: 1 NOV 2011

DOI: 10.1002/9781118093955.ch19

Excel for Chemists®: A Comprehensive Guide, Third Edition

Excel for Chemists®: A Comprehensive Guide, Third Edition

How to Cite

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

Publication History

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

ISBN Information

Print ISBN: 9780470381236

Online ISBN: 9781118093955

SEARCH

Keywords:

  • command macros;
  • format text;
  • chemical formula;
  • sub procedure;
  • selected range

Summary

This chapter contains sections titled:

  • Creating Advanced Macros in VBA

  • A Sub Procedure to Format Text as a Chemical Formula

  • A Sub Procedure to Apply “Precision as Displayed” to a Selected Range of Cells

  • A Sub Procedure to Apply Data Labels in a Chart

  • Quick Chart: Create Excel 2007/2010 Charts with One Click