How do I change two cell values in the ShapeSheet with one action

[ChrisG]

I need to change two cell values (Property.Type and BeginArrow) with one
action. I can set one value using the SETF function, but I don't know how to
change both.

Thanks..

 

[John Goldsmith]

Hello Chris,

you can join these together with a + sign. So:

=SETF("Prop.Type",1)+SETF("BeginArrow",1)

...will change both to 1.

Best regards

John


John Goldsmith
www.visualSignals.co.uk

 

[Chris Roth [MVP]]

Hi Guys,

A slight modification to promote good ShapeSheet health and best practices:

add the GetRef() function inside of your SetFs:

SETF(GetRef(Prop.Type), 1) + SETF(GetRef(BeginArrow), 1)

GetRef allows you to *really* reference a cell, as opposed to burying it
inside quotes and hoping you spelled it correctly.

Also, if the cell name changes, GetRef will follow along, whereas the quoted
cell name would then be broken. This could happen with Prop.Type, but
BeginArrow is not likely to change names.

--
Hope this helps,

Chris Roth
Visio MVP

Free Visio shapes:
http://www.visguy.com/category/shapes
Visio programming info:
http://www.visguy.com/category/programming/
Other Visio resources:
http://www.visguy.com/visio-links/

 

[ChrisG]

Thanks..

Hello Chris,

you can join these together with a + sign. So:

=SETF("Prop.Type",1)+SETF("BeginArrow",1)

...will change both to 1.

Best regards

John


John Goldsmith
www.visualSignals.co.uk