• Skip to main content
  • Skip to primary sidebar
  • Skip to footer

bVisual

  • Home
  • Services
    • How Visio smartness can help your business
    • Visio visual in Power BI
    • Visio Consulting Services
    • Visio Bureau Services
    • Visio Training and Support Services
  • Products
    • Visio Shape Report Converter
    • SS Plus
    • LayerManager
    • visViewer
    • Metro Icons
    • Rules Tools for Visio
    • The Visio 2010 Sessions App
    • Multi-Language Text for Visio
    • Document Imager for Visio
    • multiSelect for Visio
    • pdSelect for Visio
  • Case Studies
    • Case studies overview
    • Using Visio in Education for GIS
    • Visualizing Construction Project Schedules
    • Visio Online Business Process Mapping
    • Nexans Visio Template
    • CNEE Projects, WorldCom
    • Chase Manhattan Bank
  • News
    • Recent news
    • News archive
  • Resources
    • Articles➡
      • ShapeSheet Functions A-Z
      • Comparing Visio for the Web and Desktop
      • Customising Visio Shapes for the Web App
      • Key differences between the Visio desktop and web apps
      • Using the Visio Data Visualizer in Excel
      • Using Visio in Teams
      • Creating Visio Tabs and Apps for Teams with SharePoint Framework (SPFx)
      • Designing Power Automate Flows with Microsoft Visio
      • Innovative uses of Visio Lists
    • Webcasts ➡
      • Visio in Organizations
      • My session and other Visio sessions at MSIgnite 2019
      • Power up your Visio diagrams
      • Vision up your Visio diagrams
      • The Visio 2010 MVP Sessions
    • Visio Web Learning Resources
    • Books➡
      • Visualize Complex Processes with Microsoft Visio
      • Mastering Data Visualization with Microsoft Visio
      • Microsoft Visio Business Process Diagramming and Validation
      • Visualizing Information with Microsoft Visio
  • Blog
    • Browse blog articles
    • Visio Power BI articles
    • Visio for Web articles
    • A history of messaging and encryption
  • About us
    • About bVisual
    • Testimonials
    • Bio of David Parker
    • Contact Us
    • Website Privacy Policy
    • Website terms and conditions
    • Ariba Network

bVisual Blog by David Parker

Published on March 14, 2011 by David Parker

How to Run VBA Macros from a Ribbon Button in Visio 2010

A colleague, who is an experienced Visio tutor, asked me how to hook VBA macros to the Fluent UI Ribbon. He figured that it must\should be easy, but he can’t see where it is done. Well, this question has resonance because a plea was made to the Microsoft Visio team at our recent MVP Conference that this often asked for feature should be made easy for the macro developer. Now, I must admit that I have been so busy writing .Net Visio Add-Ins and following the pattern for the Fluent UI in VSTO C# code, that I had not appreciated just how convoluted the calling of VBA from a Ribbon button is. So, I thought I would offer a way of doing this in a simple (I hope!) way.

I will show how this can be done for a Visio drawing or template that contains VBA macros, and how this can be also be used for a Visio stencil that contains the code. I know that some macro developers put their code into drawings, but I would always recommend putting the code into a stencil, if the code is to be used by multiple drawings.

The Visio team’s Insight Blog has some useful background at http://blogs.msdn.com/b/visio/archive/2010/02/24/user-interface-extensibility-in-visio-2010.aspx , but it only has one fleeting mention of VBA macros:

For VBA, you simply provide the contents of a RibbonX XML as a string directly to Visio through the CustomUI property.

So, what does that mean? How do you actually do it?

Well, there is some sample code in the Visio 2016 SDK.

[Read more…] about How to Run VBA Macros from a Ribbon Button in Visio 2010

Filed Under: VBA, Visio 2010

Published on February 28, 2011 by David Parker

Another Dot Grid …

My good friend, John Goldsmith, recently published a blog about how to create a printable dot grid in Visio (see http://visualsignals.typepad.co.uk/vislog/2011/02/dot-grid-backgrounds.html#more ). This inspired me to share another way that you can create a dot grid in Visio. This time I will use a custom fill pattern, rather than new shape. This has the advantage that the fill pattern can be applied to any shape, and will repeat the pattern as much as is required to completely cover the shape.

In the following example, I have just drawn a rectangle, and applied a new custom Fill Pattern, called Grid.

To create this pattern, just open the Drawing Explorer then select New Pattern from the right mouse action. Name the pattern, ensure that the Scaled option is ticked, and that the behaviour is set to the first option (repeat).

[Read more…] about Another Dot Grid …

Filed Under: FillPattern, ShapeSheet Formulas, Visio

Published on January 31, 2011 by David Parker

Help me raise money during FebruHairy for Sue Ryder Care

http://uk.virginmoneygiving.com/DavidParker

Filed Under: Uncategorized

Published on January 31, 2011 by David Parker

Using Character Map Symbols as Data Graphic Icons

I attended the ninth DDD on Saturday (see http://developerdeveloperdeveloper.com/ ), and, as usual, there were many interesting presentations. Sam Bourton extolled the virtues of Microsoft Expression Blend for WPF and Silverlight developers (NOT designers note!), and he showed a neat trick to create icons quickly by using Wingding symbols. Basically, he created a text block in Blend, inserted a symbol from one of the three Wingding fonts character maps, then converted the symbol to a path. It struck me that we could do a similar trick in Visio to create Data Graphic Icon Sets cheaply … so here goes…..
In this example, I am using a Process shape from the Basic Flowchart stencil because it has a Status Shape Data row that is defined as a choice from six different values (the first value is an empty text string).

Choice of Values for Status Shape Data row

[Read more…] about Using Character Map Symbols as Data Graphic Icons

Filed Under: Data Graphics, Shape Data, ShapeSheet Formulas, Visio, Visio 2010

Published on January 21, 2011 by David Parker

Congrats to another Visio chap in the UK

Those of you who use the Microsoft Office and TechNet Forums may have noticed that I don’t answer too many questions there. Firstly, this is because I am normally beaten to it by John Marshall (Canada), Al Edlund (USA), or Paul Herber (UK). Well, the first two are Microsoft MVP’s for Visio (like me), but Paul has just achieved something that most MVP’s have not … he has been awarded a second medal for his activity on the Visio forums (John Marshall was the first I believe). So, congratulations to Paul!

The second reason is that I just don’t find them as easy to use as the old newsgroups that Microsoft used to host. I know that there were good reasons for the transition, but I look forward to them being improved – and Visio getting it’s own forum, rather than just being a filter on other Office products!

The Visio forums can be found at:

Microsoft Office for Business Users: Visio, Project, InfoPath, and Access : http://social.answers.microsoft.com/Forums/en-US/addbuz/threads?filter=alltypes%2cmf%3aa094743e-91c5-4bb1-a29f-87fdc36790ce

Visio General Questions and Answers for IT Professionals : http://social.technet.microsoft.com/Forums/en-US/visiogeneral/threads

Paul Herber has just started a Visio blog too : http://www.paulherber.co.uk/articles/visio-articles/

Filed Under: Visio

Published on January 14, 2011 by David Parker

Microsoft Monday at Packt Publishing

My latest book, which is about validating diagrams in Visio 2010 ( https://www.packtpub.com/microsoft-visio-2010-business-process-diagramming/book ) was published by Packt Publishing last year.
You can get 25% off during January, if you buy more than one Microsoft book from them. Please read the details at https://www.packtpub.com/article/microsoft-books .

Filed Under: Visio 2010

  • « Go to Previous Page
  • Page 1
  • Interim pages omitted …
  • Page 59
  • Page 60
  • Page 61
  • Page 62
  • Page 63
  • Interim pages omitted …
  • Page 74
  • Go to Next Page »

Primary Sidebar

  • LinkedIn
  • Twitter

Recent Posts

  • Jumping between Shapes in Visio
  • Co-authoring and Commenting with Visio Documents
  • Fixing dimensions of 2D shapes
  • Merging Linked Data from Similar Tables
  • Smart Radio Buttons and Check Boxes in Visio

Categories

Tags

Accessibility Add-Ins Connectors Containers Data Export Data Graphics Data Import Data Visualizer Educational Excel GraphDatabase Hyperlinks Icon Sets JavaScript LayerManager Layers Legend Link Data to Shapes Lists MSIgnite MVP Office365 Org Chart PowerApps PowerBI PowerQuery Processes Setup and Deployment Shape Data Shape Design ShapeSheet ShapeSheet Functions SharePoint 2013 SQL Teams Validation VBA Video Visio Visio 2007 Visio for the Web Visio Online Visio Services Visio Viewer Webinar

Footer

bVisual Profile

The UK-based independent Visio consultancy with a worldwide reach. We have over 25 years experience of providing data visualization solutions to companies around the globe.

Learn more about bVisual

  • Amazon
  • E-mail
  • Facebook
  • LinkedIn
  • Twitter
  • YouTube

Search this website

Recent posts

  • Jumping between Shapes in Visio
  • Co-authoring and Commenting with Visio Documents
  • Fixing dimensions of 2D shapes
  • Merging Linked Data from Similar Tables
  • Smart Radio Buttons and Check Boxes in Visio

Copyright © 2025 · Executive Pro on Genesis Framework · WordPress · Log in