Fix for Data Entry Form

Hey!

I was wondering if anyone could help... I've found sample code I'm playing around with on Excel but I'm a bit confused how to fix something relating to the data entry form. Basically it works ok... but whenever the first field of the data entry form is not completed, the row I enter replaces the previous one. I hope that makes sense. Basically, you HAVE to enter something in the first field of the form otherwise it won't add to the spreadsheet a row below the last. It's a bit confusing to explain but I've attached the file to this post.

Oh and also, the exit button from the form isn't working. I can't understand why not. If anyone can shed any light on this, I'd be very grateful!

I hope someone could tell me where I'm going wrong?

Thanks

I've also asked this here: http://www.mrexcel.com/forum/showthr...65#post3232765