Results 1 to 5 of 5

Thread: [RESOLVED] [Excel 2010] Program breaks and I don't know why

Threaded View

  1. #1

    Thread Starter
    New Member
    Join Date
    Aug 2012
    Posts
    3

    Resolved [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.
    Attached Files Attached Files

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  



Click Here to Expand Forum to Full Width