Visio Guy

Visio Discussions => ShapeSheet & Smart Shapes => Topic started by: abssorb on January 26, 2012, 04:26:20 PM

Title: Is it possible to make user-defined fields refer to another based on a variable?
Post by: abssorb on January 26, 2012, 04:26:20 PM
I have a number of shapes which pull a number of attributes from the Page shapsheet.

Shapes have about 10 user-defined cells. Three of which link to the page shapesheet.
E.g.
QuoteFirst shape
=ThePage!Scratch.A1
=ThePage!Scratch.B1
=YEAR(ThePage!Scratch.C1)

Second shape
=ThePage!Scratch.A2
=ThePage!Scratch.B2
=YEAR(ThePage!Scratch.C2)

Third shape
=ThePage!Scratch.A3
=ThePage!Scratch.B3
=YEAR(ThePage!Scratch.C3)

Is there a way to do something like....:
QuoteAll Shapes

User.KeyValue=1
=ThePage!Scratch.A[User.KeyValue]
=ThePage!Scratch.B[User.KeyValue]
=YEAR(ThePage!Scratch.C[User.KeyValue])
?

It would open up a lot of possibilities for where I'm heading with automation.
Title: Re: Is it possible to make user-defined fields refer to another based on a variable?
Post by: Yacine on January 26, 2012, 09:03:40 PM
SetF/GetRef will do the job.
Title: Re: Is it possible to make user-defined fields refer to another based on a variable?
Post by: abssorb on January 27, 2012, 03:34:09 PM
Perfect Yacine!  Thanks very much  :D