Class module to access range events
On Apr 14, 11:25*pm, "Jim Cone" wrote:
Mark,
Each Excel sheet has its own class module.
Right click the sheet tab and choose View Code.
Included in that module are several events including one that
occurs with every change in a cell.
There are two dropdowns at the top of the module.
Select "worksheet" in the left dropdown and "change" in the right dropdown.
|