[RESOLVED] [Excel 2010] Program breaks and I don't know why
I've been developing this user form that is going to be used to assist in rating insurance policies. originally the program was meant to (at least I designed it to) allow the user to make the proper calculations and then print a copy of the form; however, they now want to be able to save the data on the form so they can go back and edit it if they have to. Since it was never designed to do so,and I have to recollection of being able to save on a user form, I decided to have the data stored on one of the work sheets within the excel work book. the data would then be imported into the from either at start up or from a button (haven't decided how I will approach this).
the main problem that Iv'e encountered is that within one of the data exporting scenarios is that that it will simply break when i run it, no error will be thrown and the line of code that is causing issues will be hi-lighted. I'm pretty sure it's not a syntax error, be then again it's hard to catch your own errors. Also i was wondering if it is at all possible to have the data imported at form termination the way the data will already be there at start up.
I have attached the Excel file, i apologize if my code is sloppy or hard to read, I'm an amateur when it comes to coding.