Text only | Text with Images

Visio Guy

Visio Discussions => Programming & Code => Topic started by: gtakla on November 13, 2016, 07:50:40 PM

Title: Trigger shape custom action from VBA
Post by: gtakla on November 13, 2016, 07:50:40 PM
Hi,

I need to trigger an action row in a shape from VBA.
Thanks
gt
Title: Re: Trigger shape custom action from VBA
Post by: Yacine on November 13, 2016, 08:27:59 PM
Interesting. The other way around.
Could you think of modifying the action row by adding a "dependson" predicate?
This way you could modify a cell that is "depended on", this will trigger the formula in the action row.
Title: Re: Trigger shape custom action from VBA
Post by: gtakla on November 14, 2016, 12:20:11 AM
Thanks. I figure it out and it is  the same solution you mentioned.  :D
gt
Title: Re: Trigger shape custom action from VBA
Post by: JohnGoldsmith on November 14, 2016, 07:38:01 AM
Another way would be to invoke the Trigger method on the cell you're after.  For example, something like:


myShape.CellsU("myActionCellName").Trigger


best regards


John
Text only | Text with Images
Browser ID: smf (is_webkit)
Templates: 1: Printpage (default).
Sub templates: 4: init, print_above, main, print_below.
Language files: 1: index+Modifications.english (default).
Style sheets: 0: .
Hooks called: 50 (show)
Files included: 25 - 925KB. (show)
Memory used: 766KB.
Tokens: post-login.
Cache hits: 7: 0.00099s for 22,301 bytes (show)
Cache misses: 1: (show)
Queries used: 9.

[Show Queries]