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

C

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..
 
C

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/
 
Top