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
Thanks,
John