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:
P(X <= x) and P(X > x).

SQL Insert Statment Generation

An workbook with a user-defined function, converting rows of an Excel tables into SQL-Insert statetements.