How to use shapesheet data in another shape?

[HansNL]

Hi, I'm new to this forum and starting to use Visio for groudwater well design.

How can I use a certain shapesheet cell from a shape as a cell (or part of an expression) in a shapesheet cell of another shape?

Regards, Hans

[Surrogate]

same topic

[Yacine]

In the shape sheet of the referenced shape, the title of the window shows the shape's ID.
Use this number N in the referencing shape.
eg: sheet.N!width

@Surrogate, you were faster. And an extensive reference is probably better than to start at the beginning every time. Cheers.

[Surrogate]

@Yacine, may be beginner didn't know where find for shape's ID... 

Just another way
1.  Select shape that name you need to know
2.   Press keys Alt+F11
2a. If in VBA editor you can't see Immediate Window, press Ctrl+G and press Enter
3.  In Immediate Window paste this code

Code Select Expand

?"Pages[" & ActiveWindow.Selection(1).Parent & "]!sheet." & ActiveWindow.Selection(1).ID
Profit: in second line in Immediate Window you get full reference to selected shape

[Surrogate]

Sorry, correct code is:

Code Select Expand

?"Pages[" & ActiveWindow.Selection(1).Parent.NameU & "]!sheet." & ActiveWindow.Selection(1).ID

[HansNL]

thanks