Hi,
I've asked this question in the Eng-Tips forum, and someone recommended trying this forum, so here goes...
I'm trying to generate a Shape object with custom connection sites (which can attach to a Connector object). I want to be able to place as many connection sites as I please, and place them where I want them. In addition, I need to be able to add text to the Shape. I've tried using the FreeFormBuilder, which will place connection sites at the vertices of the FreeForm object I define, but the FreeForm object apparently doesn't contain a TextFrame property. If I could get a rectangle with text and twelve (instead of four) evenly spaced connection sites, that would be enough for now.
Can anyone do this?
Thanks
- olindude
P.S. By the way, I'm doing this in VBA (6.3) for Excel 2000
I've asked this question in the Eng-Tips forum, and someone recommended trying this forum, so here goes...
I'm trying to generate a Shape object with custom connection sites (which can attach to a Connector object). I want to be able to place as many connection sites as I please, and place them where I want them. In addition, I need to be able to add text to the Shape. I've tried using the FreeFormBuilder, which will place connection sites at the vertices of the FreeForm object I define, but the FreeForm object apparently doesn't contain a TextFrame property. If I could get a rectangle with text and twelve (instead of four) evenly spaced connection sites, that would be enough for now.
Can anyone do this?
Thanks
- olindude
P.S. By the way, I'm doing this in VBA (6.3) for Excel 2000