Can I inherite an object from Excel like "Rectangle" in order to add it properties like input1 as integer, output1 as integer, ... inputn as integer etc.?
Printable View
Can I inherite an object from Excel like "Rectangle" in order to add it properties like input1 as integer, output1 as integer, ... inputn as integer etc.?
why you are not using vb this have more then function you want.
Ok! It's not important if I use Excel's object (like "Rectangle") or VBA created one. The point is how can I create an inherited object and draw it on a sheet? Further a double-click on that objects must give infomations about their properties (inputs and outputs).
What version of Office are you running and are you wanting to do this in VBA or VB6/.NET?
I use VBA 6.3 on Excel 2002
Looking at your input and output properties you want, if your not wanting to amke it a control for adding to your toolbox or something then you can just create a rectangle in a class and add some properties to it.
Thanke you! But can you give me an example? It's easier to understand.