bVisual

bVisual Blog by David Parker

Published on by

Fixing dimensions of 2D shapes

I am often asked what makes Visio unique and makes it stand out from the crowd, especially in today’s online world. Well, I think there are many reasons, but one of them is the ability to create scaled drawings with parametric components of specific dimensions. This was crucial for my adoption of Visio back in 1996 (see Chase Manhattan Bank – bVisual ), and since then I have created hundreds of dimensionally accurate catalogue components for use in scaled drawings for multiple manufacturers. Over the years, I have developed some patterns in ShapeSheet formulas that I re-use consistently. In this article I show the pattern that I use to provide a user with specific width and height dimensions that can be selected in any of three ways:

  1. Manual resize of the shape with the shape handles to only the specified sizes
  2. Selecting a dimension from the Shape Data panel
  3. Selecting a dimension from the right-mouse Actions context menu

All of these options are linked together so that editing the list of specific sizes are easy to maintain.

  • Resize manually
  • Select a Shape Data value
  • Select a context menu Action
[Read more…] about Fixing dimensions of 2D shapes

Published on by

Merging Linked Data from Similar Tables

I was recently asked how to link data from different tables but with similar column names to Visio shapes. In this case, each table has the same unique identifier, but some of the column names are the same. The problem is that the data linking matches the column name with the label of a Shape Data row label, so the shared columns were updated with the values from the last linked data recordset. In this article I present a simple way that this restriction can be overcome.

[Read more…] about Merging Linked Data from Similar Tables

Published on by

Smart Radio Buttons and Check Boxes in Visio

A recent project requires an interactive tutorial within Microsoft Visio desktop where a lot of the questions need a single answer using radio buttons, or multiple-choice answers using check boxes. I thought that this would be a great use of the list containers capability because the questions and answers could be part of the container shape whilst the individual questions are presented as items in the list and automatically inheriting their particular question text from the containing list shape. So, this article provides these smart master shapes, and explains how they are built.

  • In Tutor mode, the Questions, Answers, Explanation and More Info can be edited
  • In normal mode, the Questions are presented unmarked and without explanation
  • Incorrect answers are marked with a red cross. An explanation and optional more info hyperlink is available
  • Correct answers are marked with a green tick. An explanation and optional more info hyperlink is available.
[Read more…] about Smart Radio Buttons and Check Boxes in Visio

Published on by

Using Button Face Ids in Visio

Microsoft Visio desktop has the ability to display icons from a built-in list of Office icons on Actions and Action Tags (nee Smart Tags). These can be set in the ShapeSheet by using the desired number from several thousand in the ButtonFace cell. Although there is the ability to add better icons using code, the quick ShapeSheet formulas are useful way of indicating the purpose of a command. This article simply lists the first 3,600 of these fas a quick and easy reference for me, and othe ShapeSheet disigners out there!

  • Face Ids from 0001 to 0360
  • Face Ids from 0361 to 0720
  • Face Ids from 0721 to 1400
  • Face Ids from 1441 to 1800
  • Face Ids from 1801 to 2160
  • FaceI ds from 2161 to 2520
  • Face Ids from 2521 to 2880
  • Face Ids from 2881 to 3240
  • Face Ids from 3241 to 3600
[Read more…] about Using Button Face Ids in Visio

Published on by

Grid Snapping Revisited

I have previously tackled the subject of snapping to grids in Visio desktop (see https://bvisual.net/2018/06/19/really-snapping-to-grids-in-visio/ ) but a recent project required me to improve the example because it did not respond to all cursor arrow keys. The problem was that the previous solution could not understand which arrow key had been clicked, therefore it did not know if to reposition to the previous or next grid. The new ShapeSheet code solution can now respond to the correct arrow key … and all without any add-in. In addition, I also show how a Control point can be made to snap to a grid spacing, and how AutoConnect can be set to add the next shape at the right offset in both the horizontal and vertical directions.

Lastly, Microsoft released the web edition of Visio since the last article, and I demonstrate the difference behaviour of grid snapping between that and the desktop edition.

  • Set the Horizontal and Vertical Grid Spacing
  • Turn OFF Snap to Ruler subdivisions and Grid ON
  • Edit Space between Shapes for AutoConnect
[Read more…] about Grid Snapping Revisited

Published on by

Optimize Visio Flowcharts: Swimlane Reordering Tips

Microsoft Visio desktop Plan 2 and Professional editions provides the ability to create and synchronize cross-functional flowcharts between the diagram and an Excel table. This is great, and widely used for many types of processes. The Excel table normally has a Function / Swimlane column that contains text that becomes labels on the swimlane containers, and a Phase / Timeline column that contains text that becomes the label of the phase or separator containers. The import provides the option to order the diagram by Function and/or Phase, but it is impossible to get them ordered by both! This article provides a solution using a free macro-enabled Visio stencil.

  • Excel table with Function and Phase columns
  • Visio Data \ Create from Data
  • Step 2 More Options to order by Phase
[Read more…] about Optimize Visio Flowcharts: Swimlane Reordering Tips