Worksheet change function to add enter to specific column

[spectraflame]

I have a column (D) with a manually keyed in number. I would like to input either a positive or negative number in column E and then automatically add or subtract the E value to the D value and clear the contents of E.

If D contains the value of 100 and I key in 25 in column E, the value in column D would change to 125 and column E would then be blank.

I feel that a worksheet change function would do this, but I have no idea where to begin.

Matthew

 

[spectraflame]

Re: Worksheet change function to add enter to specific colum

I just added deleted everything out of the worksheet_change window, saved the file, closed the file, reopened it, copy the code back in, saved it and now everything is working.

That is very odd.

I appreciate your time and patience with me.

Thanks again,
Matthew