"user defined functions" in Visio?

[rhatcher]

Is it possible to use "user defined functions" in Visio VBA like in
Excel?
I tried the following:

Function HypotenuseLength(x, y)

HypotenuseLength = Sqr(x ^ 2 + y ^ 2)

End Function

VBA (Visio) accepted the function, however, I cant seem to use it in
the shapesheet.

 

[Al Edlund]

I believe the ability to execute code within the shapesheet is very limited
(and does not include user functions)
al

 

[rhatcher]

Ahh, That explains it.
Thanks

for a work around I might get away with creating a procedure that just
runs the FUNCTION and use "CallThis" from the spreadsheet to access the
procedure

 

[Mark Nelson [MS]]

You can do that, yes. Just be aware that CALLTHIS and other code execution
functions are run after recalc is completed in a Shapesheet. This is a
subtle timing issue that may or may not be a problem for you.

--
Mark Nelson
Office Graphics - Visio
Microsoft Corporation

This posting is provided "AS IS" with no warranties, and confers no rights.