single cell for data entry

This is a follow up question to a topic I had posted a few months ago. JBeaucaire and Leith, your help was tremendous on this and the resulting script has worked flawlessly. Here is a link to the original thread.

http://www.excelforum.com/excel-prog...ata-entry.html

Here is the script as it stands now with no modifications at all.

Please Login or Register  to view this content.

Currently column (S) is my data entry cell and the immediate following cells starting with column (T) are my "data collection" cells that react to column (T) input.

I have had to add two columns directly after column (S) for other purposes and one of them (column U) contains a formula . I tweaked the code and was able to get it working again after I added the two columns but I experienced something strange. If I press the delete key in my data entry cell it wipes my formulas out of column U.

What is the "correct" way to tweak the code so that column (T) and (U) are unaffected or ignored and column (V) being my first "data collection" column.

With the changes that I made I was able to get it to work but I soon realized the problem with an "accidental" press of the delete key or a cut command has the same affect of wiping out my new formulas. I just need to try and prevent accidents from occuring.

J.B. or Leith I was hoping you had some insight on this.

BTW... I have noticed one small thing, if the data entered is not a number...letter for instance I get a run time error 13 (type mismatch) which is not even a big deal and I can live with it as it really doesn't affect the use of the sheet... usually just press end and resume data input.

Thanks
Barry C

Actually that was the first thing that I did and it does fix the offset problem. Still though I am faced with the problem of an erroneous press of the delete key or such wipes out my new data/formula in column U(which is column 21). I just need to eliminate the possibility of user error on this sheet if at all possible.

Thanks for the input.

BC

Actually that did work. The delete has no effect what-so-ever. Thanks so much!

but

I just noticed the numeral "0" has the same affect that the delete key was having. Apparently that problem was there as well since I made the spreadsheet changes. I tried to modify it with the following:

Please Login or Register  to view this content.

and

Please Login or Register  to view this content.

Although I'm not enough of a coder to consider myself even a "bad coder", it did compile and the code still ran without problems but just didn't work to kill the zero problem now.

Any insight?

Thanks
BC