Author Topic: Link shapes on different pages  (Read 2456 times)

0 Members and 1 Guest are viewing this topic.

jeffc

  • Newbie
  • *
  • Posts: 5
Link shapes on different pages
« on: January 16, 2014, 12:24:55 PM »
Hello, first post -- long time lurker.

My Visio knowledge is fairly limited, and hence am challenged while trying to resolve this issue.  What I am trying to accomplish is using a formula in one shape, to extract data from a shape on a different page.  This is for Audio/Visual drawings where a cable is split between two pages; I use a custom callout on each page with a hyperlink connecting them.  I've tried using <=Pages[Prop.Remote_Page]!Prop.Remote_ID!User.Grid>.  Whether I use the shape data method or directly entering the information into the cell's formula, I get an error.  It's really frustrating me as to why I cannot get it to work.  Is there a better way to go about this?  I'm a stranger to VB as well, but will do what I must to make this happen.  Thanks in advance for an and all help!

jeffc

  • Newbie
  • *
  • Posts: 5
Re: Link shapes on different pages
« Reply #1 on: January 16, 2014, 02:22:26 PM »
Ok, let me throw one more thing out there; since this is a shape linked to a master, should I be using the following formula?

Masters[Mastername]! Shapename!Cellreference

Will it traverse pages without any other coding?

Jumpy

  • Hero Member
  • *****
  • Posts: 1061
Re: Link shapes on different pages
« Reply #2 on: January 17, 2014, 02:19:41 AM »
I presume that the page and the shape you want to link are stored inside the propertys that are referenced in your formula?

=Pages[Prop.Remote_Page]!Prop.Remote_ID!User.Grid

That wont work, because if Prop.Remote_Page="Page-1" and  Prop.Remote_ID="Sheet.123" then what you have in the formula is sth. like:

=Pages["Page-1"]!"Sheet.123"!User.Grid

Your propertys will be interpreted as strings I guess. So you either don't use the propertys and place Page and Shape directly in formula:

=Pages[Page-1]!Sheet.123!User.Grid

or u create a new user defined cell with a formula like:

=DEPENDSON(Prop.Remote_Page)+SETF(GETREF(User.MyCell),"=Pages["&Prop.Remote_Page&"]!"&Prop.Remote_ID&"!User.Grid")

that pushes the correct formula to the cell User.MyCell whenever Prop.Remote_Page changes. Use similar formula for changes in Prop.Remote_ID or add a second Dependson to the one formula abobe, but I don't know if that will work.

JamesB

  • Newbie
  • *
  • Posts: 2
Re: Link shapes on different pages
« Reply #3 on: August 27, 2018, 12:17:48 AM »
Any results Jeffc?

Surrogate

  • Hero Member
  • *****
  • Posts: 1094
    • ShapeSheet™ Knowledge Base
Re: Link shapes on different pages
« Reply #4 on: August 27, 2018, 01:45:30 AM »
This thread can be helpful!