Hello Guys, I don't like long introductions so I will write it short: I am begging excel and OOP. I know normal VBA quite good (that is: it helps me more than it impedes me) but I think that my next project would be difficult without oop. I am working on workbook which will allow people to plan production in my company. I am planning to store data in an Microsoft Access Database and use Excel only to manipulate/ change/add/remove new data. Basic view will be something like production lines in rows, when data will be changed, it will grab the planed tranches from Access db, mangle them and format the rows, so it would be obvious where and when goods will be produced. Tbh, it sounds simple but in fact is quite complicated (that is, I must consider supplies before and after production, substitutes for material, material formulas, blocking items so only one person can edit tranche at a time, etc). I have a vision of that in my head - but I lack the technical knowledge about oop. I will be grateful, if someone would answer me those questions:
1) Is it posible in Excel/VBA to do inheritance of custom created classes ? 2) I am planning to show tranches as rightly formated and placed autoshapes. Is it possible to extend autoshape class? Is there any other way to present tranches in my sheet, so they would look good plus will at least have a way to attach information about id of the tranche to them? 3) Is it possible to write custom events in Excel. You see, lets say that someone would think like "Hey, I need to make this tranche 2h longer" - I thought about making some kind of controls attached to an autoshape which would allow me to easilly manipulate it in an controlled way. 4) Right now, I thought about this object hierarchy: * DBase - connection with db * ProductionPlan - info about date, formating, etc. It would have a collection of facilities. * Facility - would have an collection of ProductionLines * ProductionLine - info about where it is, when it is taken, would have collection of tranches. * Tranche - what products are in tranche(collecion), when it starts, which line, etc. Is this a good way of thinking? Or maybe not? I would be grateful, if You could send me links to information about custom classes in Excel and oop in Excel in general. Sorry for my English - it is not my primary language (yeah, You didn't noticed:P) Best regards, Mike. --~--~---------~--~----~------------~-------~--~----~ ------------------------------------------------------------------------------------- Some important links for excel users: 1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at http://www.excelitems.com 2. Excel tutorials at http://www.excel-macros.blogspot.com 3. Learn VBA Macros at http://www.vbamacros.blogspot.com 4. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com If you find any spam message in the group, please send an email to: Ayush Jain @ jainayus...@gmail.com or Ashish Jain @ 26may.1...@gmail.com ------------------------------------------------------------------------------------- -~----------~----~----~----~------~----~------~--~---
