MontySharpei
09-12-2008, 11:54 AM
Hello,
I hope someone can help. Attached is a sheet Im working on. When the comand button is pressed the userform pops up. The fields are filled out and when it is closed the spreadsheet cells are populated and various calulations are carried out accordingly.
So here is my problem, I fill out the fields and press ok for the spreadsheet to be populated. fine works ok. now i want to add a new line with different numbers. so i go through the userform and fill out the blanks. Now when I press ok and a new line is created in the spreadsheet its cells populated, but my old figures in the old line are replaced with the new ones too !!
can anyone stop it doing this, or alternatively suggest a way i can lock out the line so it cant be further updated.
Thankyou !
I hope someone can help. Attached is a sheet Im working on. When the comand button is pressed the userform pops up. The fields are filled out and when it is closed the spreadsheet cells are populated and various calulations are carried out accordingly.
So here is my problem, I fill out the fields and press ok for the spreadsheet to be populated. fine works ok. now i want to add a new line with different numbers. so i go through the userform and fill out the blanks. Now when I press ok and a new line is created in the spreadsheet its cells populated, but my old figures in the old line are replaced with the new ones too !!
can anyone stop it doing this, or alternatively suggest a way i can lock out the line so it cant be further updated.
Thankyou !