Author Topic: Is it possible to make user-defined fields refer to another based on a variable?  (Read 1957 times)

0 Members and 1 Guest are viewing this topic.

abssorb

  • Jr. Member
  • **
  • Posts: 42
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.
Quote
First 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....:
Quote
All 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.

Yacine

  • Hero Member
  • *****
  • Posts: 2703
SetF/GetRef will do the job.
Yacine

abssorb

  • Jr. Member
  • **
  • Posts: 42
Perfect Yacine!  Thanks very much  :D