Excel Macros for PChem, Project 3
This video shows an example of how to set up spreadsheet as a reviewer. The spreadsheet asks a user to determine the pressure (in atm) due to a liquid column given the height in cm and the density in g/mL. Creation of the spreadsheet illustrates the following VBA skills: set a macro to automatically run when the spreadsheet is opened, use command button to execute a procedure, use a random number generator, round off numbers, define global variables.