Now when we select Toggle on the shape's menu the value in cell User.Toggle will alternately be TRUE and FALSE. in the Action cell add the formula =SETF(GetRef(User.Toggle), NOT(GetRef(User.Toggle))) in the Menu cell add the text that you want to appear on the shape's right click menu (typically set the text to 'Toggle')Īssume we wish to toggle cell 'User.Toggle':ģ. Set cell Text Transform -> TxtAngle = -ANG360(Angle)Ģ. Level text - text that is always horizontal, sometimes called 'gravity text':.Set cell Character -> Size = MIN(48 pt, Max(4 pt,10 pt*Height/0.75 in.)) Resizing text with the shape (with minimum and maximum values):.Set cell Character -> Size = 10 pt*Height/0.75 in Set cell Height = GUARD(TEXTHEIGHT(TheText,Width)) Set cell Width = GUARD(MAX(TEXTWIDTH(TheText), 10mm)) Resizing shape's width with text, but with a minimum size (10mm in this case):.Set cell Width = GUARD(TEXTWIDTH(TheText)) Various useful formulae for use in Visio shapesheet cells Keng Tiong's Visio website - books, templates and blog.Microsoft Community (was Answers) Visio forum at.Many free Visio stencils, templates and add-ons available from.Paying my dues First of all I need to pay my dues to the other Visio websites, blogs and forums, so, in no particular order: Visio and Python - a getting started guide.Visio Guy - General Visio support forum.Output dialog box for showing text when a shape is double-clicked.Super Utilities and Tools V2 (for Visio 20).

Visio 2016 bpmn stencil download