| SUBJECT | CLICK | |
 |
Recording and Customizing an Excel Macro A step-by-step instruction for recording an Excel macro. The macro is expected to generate Excel labels and functions to calculate major statistical position-summary measures. The instruction also shows how to add a dialog box and how to modify (generalize) the code. |
|
|
Cell Manipulation Macros A few examples showing how to access and manipulate spreadsheet cells from within VB procedures, using the Cells and Offset methods. |
|
|
A Simple Dialog Box The dialog box accepts from a user an input
and produces an output in a message box. The input
consists of the Normal probability distribution parameters, Mu,
Sigma, and random variable value, x.
The output consists of two probabilities: |
|