Linking Properties and a bunch of other questions

[kurt.acm]

1.)
I would like to link a custom property of one shape to the custom
property of another shape.
i.e.
Shape 1
Name: AV Rack
Shape 2
Connect To: Shape1!Name

I know this is possible I just can't find the any info on how to do it.

2.)
Is it possible to have a list box display all the available shapes of
a certain type/name?
i.e.
Amp1
Amp2
Amp3

3.)
Is there a good site that shows how to import custom properties from
an access database?

 

[Paul Herber]

1.)
I would like to link a custom property of one shape to the custom
property of another shape.
i.e.
Shape 1
Name: AV Rack
Shape 2
Connect To: Shape1!Name

You're almost there.
If you want to link to shape Square.2 to Square.3 and the custom
property Prop.height then just set the required cell value in Square.2
to something like

=Square.3!Prop.height

 

[kurt.acm]

The shape I'm linking from is A/V Rack. The shape I'm linking to is
Speaker Cable

I have a custom Prop.Rack_Name for the A/V Rack.
I have a custom Prop.Run_To for the Speaker Cable
I have tried entering =A/V Rack!Prop.Rack_Name into Run_To Value
cell and I get an error in formula pop-up.
I have also tried =A/V Rack!Prop.Rack_Name.Value
=Page-1!A/V Rack!Prop.Rack_Name
=Page-1!A/V Rack!Prop.Rack_Name .Value

Can you please give me a proper formula.

 

[Paul Herber]

The shape I'm linking from is A/V Rack.

First of all you have introduced a nice little problem by using the
divide symbol '/' into the shape name !
Luckily there is a way around this - just put the shape name within
single quotes 'A/V Rack'

The shape I'm linking to is
Speaker Cable

I have a custom Prop.Rack_Name for the A/V Rack.
I have a custom Prop.Run_To for the Speaker Cable
I have tried entering =A/V Rack!Prop.Rack_Name into Run_To Value
cell and I get an error in formula pop-up.
I have also tried =A/V Rack!Prop.Rack_Name.Value
=Page-1!A/V Rack!Prop.Rack_Name
=Page-1!A/V Rack!Prop.Rack_Name .Value

try ='A/V Rack'!Prop.Rack_Name
etc

 

[vojo]

I would bet the "/" and the space is the issue.

You should be able to do

A/V rack......Prop.AV_rack
Cable..........Prop.Run_To

and Prop.Run_To = Mycoolrack!prop.AV_rack

As far as drop downs goes
- can do with VBA et al
- Can do with user cells and visible/invisible field on prop.

 

[kurt.acm]

Thanks everybody
I changed the name to AV Rack and it worked.

Does anyone now a site with VBA examples? I have so many things a want
to do but an next to clueless about VBA. I just bought Visio 2003
Inside / Out book but it doesn't seem to deal with VBA.

I would bet the "/" and the space is the issue.

You should be able to do

A/V rack......Prop.AV_rack
Cable..........Prop.Run_To

and Prop.Run_To = Mycoolrack!prop.AV_rack

As far as drop downs goes
- can do with VBA et al
- Can do with user cells and visible/invisible field on prop.

On 12 Nov 2006 22:01:45 -0800, (e-mail address removed) wrote:

First of all you have introduced a nice little problem by using the
divide symbol '/' into the shape name !
Luckily there is a way around this - just put the shape name within
single quotes 'A/V Rack'

try ='A/V Rack'!Prop.Rack_Name
etc