Error Checking in Excel
Thanks Thanks:  0
Likes Likes:  0
Results 1 to 2 of 2

Thread: Design Advice?

  1. #1
    Board Regular
    Join Date
    Feb 2002
    Location
    John G
    Posts
    62
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    I am creating an invoice system, light record-keeping system that I have mostly completed and I'm wondering if I might be going at it the wrong way. I have about 600 products that I have on hidden sheets in my main file. I launch userforms from activex controls on the main invoice sheet. I store customer information and invoice history on a separate workbook that has each invoice on a single row with stock numbers, quantities, and totals with shipping, taxes and subtotals saved separately. I end up opening and resaving every time there is a customer change or invoice being filed. I plan on disabling print and save except through activex controls or userforms. Obviously I have described something very vague, but in the description that I have provided do you see any major problems that I should try to go a different way with? Should I consider making the main file an add-in? If so, where can I get some tips on converting to an add-in? What kind of limitations am I setting myself up for. I'm fairly new to excel vba but have learned enough to put most of this together although, I'm not quite sure how to test this to make it bullet-proof(well at least semi-problem free). Is there a method of testing that I might try other than just using it as a user would. I don't have any error handling written into it other than different conditional validations and such. Where can I find information on error handling techniques and what types of errors I should expect to be seeing? This board has been immensely helpful for me in learning about excel and VBA.
    Thanks,

    John

  2. #2
    Board Regular
    Join Date
    Feb 2002
    Posts
    3,184
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Hi John

    Well i can offer a test if that help i work in finace so my kinda gig..

    And ill rip ot apart for you and report NO HOLDS BARED if you like, the ideas is to fault find, and ill offer ways to do this i have same kinda thing i help develop ...

    Your call leave email and ill email to request the sheet muct be 3mb or less thou or my Paris ofice will nick it...

    remove you data base and input 5 made up customers so you dtabese is safe,

    Remember that a good time times people eail me there total contact list????


    Free Excel based Web Toolbar available here.

    Jack in the UK
    J & R Excel Solutions
    "making Excel work for you"

Some videos you may like

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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