Using Macros That Run During Operations
An Excel file that teaches how to perform Using Macros That Run During Operations operation.
Excel Format: Using Macros That Run During Operations
Worksheet change events are enabled. Specific cell ranges are monitored. When there is a change, the control procedure is run. Incorrect entries are corrected immediately. User intervention is minimized.
Hope it is useful.