Where to place code that changes a cell value?
 

I would like the code to execute if the value of any cell changes, but I do
not want to copy the code to more than one location. I.E only one place to
update the code if maintenance is needed.

Regards
George

Where to place code that changes a cell value?
 

1) from the subject line: code that changes a cell's value ouight to be
written in a standard module. It could really go into other places, but "good
practice" would be a standard code module

2) the cell changed event can be trapped in a worksheet's code pade- this
fires when a cell's value is changed by entering a new value, NOT when a
value changes as a result of a calculation. The quick way to get to a sheet's
code page is to rioght click the tab and select the last item of th epop-up
menu.



"George Furnell" wrote:

I would like the code to execute if the value of any cell changes, but I do
not want to copy the code to more than one location. I.E only one place to
update the code if maintenance is needed.

Regards
George