Inherited objects on Exel

[klaussf]

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.?

[khurram jafri]

why you are not using vb this have more then function you want.

[klaussf]

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).

[RobDog888]

What version of Office are you running and are you wanting to do this in VBA or VB6/.NET?

[klaussf]

I use VBA 6.3 on Excel 2002

[RobDog888]

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.

[klaussf]

Thanke you! But can you give me an example? It's easier to understand.