CALLTHIS?

[Dennis King]

I'm using the CALLTHIS function in the EventDblClick cell
and it seems that only procedures in code modules can be
invoked. Is there a way to invoke a form or class module
by double clicking on a shape?

 

[GMorris]

Try using RUNADDON. I've been able to execute immediate statments with it,
like:

"=RUNADDON("frmMain.Show")" or similar.

I even got Visio to return a value from a function using this method, but
it's pretty convoluted the way you have to "jump through hoops". What would
be nice is to be able to run functions straight from a cell, like Excel,
but, at least in Visio 5, it's not that easy.

 

[al]

have you considered calling a procedure which simple is a
form show i.e.
private sub subMyProcedure
myform.show
end sub