Custom shape sheet table

[Aaron Stibich]

Is there any way to add a user defined table to the shape sheet. I need to
define the table columns, so the user data section doesn't cut it. Everything
seems to point to a hardcoded set of shape sheet sections, but I thought I'd
ask anyways.

Thanks,

Aaron

 

[Chris [Visio MVP]]

There are "User" cells and "Custom Property" cells. You can't change the
format.

You *can*, however, write any data you want into those cells, including,
say, a chunk of xml. The trick is to wrap an extra set of quotes around the
data. Ie:

shp.Cells("User.MyData").FormulaU = chr(34) & sDataChunk & chr(34)

Of course, other shape cells won't be able to make sense of that data very
easily, unless you use delimited lists (ie: "a;b;c;d;e") and use the LOOKUP
and INDEX functions to parse them.