Link to home
Create AccountLog in
Microsoft Visio

Microsoft Visio

--

Questions

--

Followers

Top Experts

Avatar of Aaron Petrie
Aaron Petrie

Visio Dynamic Connector with auto numbering
Hello,

I have downloaded a dynamic connector created by John Goldsmith
http://visualsignals.typepad.co.uk/vislog/2015/04/building-a-labelled-dynamic-connector-in-visio.html

I have edited it and am currently using it as a cable label in schematic diagrams. I find this shape very handy because it syncs the start and end connectors.

Is there a way to add in an auto numbering feature to this shape?

I would like to use a format of X001 , where X is a letter indicating the type of cable (e.g. V for video, A for audio etc).
I would then like the shape to number up by 1 when copied.

Would this be best to do as a formula in the Shape Sheet? Or by using code?

Thank you for your help, I appreciate it.

Zero AI Policy

We believe in human intelligence. Our moderation policy strictly prohibits the use of LLM content in our Q&A threads.


Avatar of Aaron PetrieAaron Petrie

ASKER

I have attached a drawing containing the connectors.
Dynamic-Connectorvsdx.vsdx

Avatar of Scott HelmersScott Helmers🇺🇸

I would start with the Number Shapes Add-On in Visio to see whether it will do what you want:
Select View>Macros>Add-Ons>Visio Extras>Number Shapes.

A couple of caveats:
1) The default settings don't number shapes as you drop them onto the page.
2) The default settings exclude connectors.
3) The default settings may add numbers to shapes you don't want numbered.

You can resolve #1 by checking the highlighted box shown at the bottom of this image. The highlighted radio button at the top of the dialog lets you click on existing shapes to number them; the second setting is part of the answer to restricting which shapes are numbered (the rest of the answer is below).User generated imageYou can resolve #2 and #3 by using the settings show in the image below. The Selected layers setting takes advantage of the fact that all dynamic connectors in Visio are automatically added to a layer called "Connector".User generated image

One other thing to note about the Number Shapes add-on: you can include a text prefix. After adding a number to a shape, take a look at the shape data fields that are added to each shape. Type any value into the field named Shape Number Text and that text will precede the number. Granted, you will need to do this manually for each shape, but you could write code to automate this action if you want to.

I don't know whether this built-in add-on will be sufficient for your needs, but let me know what you think after you experiment a bit.

Avatar of Scott HelmersScott Helmers🇺🇸

Aaron -- I'm glad to see that you did what I almost suggested yesterday, which is posting this question on John Goldsmith's blog. He's a great guy and I happen to know from private communications that he's looking into the issue...

Reward 1Reward 2Reward 3Reward 4Reward 5Reward 6

EARN REWARDS FOR ASKING, ANSWERING, AND MORE.

Earn free swag for participating on the platform.


Hello Scott,

Thank you very much for explaining the auto-numbering add on. I appreciate your assistance.

John Goldsmith has replied to my question on his blog. I will use the information that you have provided and Johns comments to create an auto-numbering dynamic connector.

Again, thank you for your assistance, I appreciate it.

Avatar of Scott HelmersScott Helmers🇺🇸

I'm glad we were able to help.

One correction to my initial response above (you may have already figured this out, but for completeness, here's the correction):
In the first dialog box above I suggested you choose "Select shapes" rather than "All shapes". That's incorrect. You'll want to choose "All shapes". The "Selected shapes" option only appears if there are one or more shapes selected at the time you invoke the Number shapes add-in and will be grayed out otherwise. The option that really does what you want -- limiting numbering to Connectors -- takes place in the second dialog box by using layers.

Feel free to leave this question open a bit longer if you think you'll need additional assistance or if you'd like to post your eventual solution (which is always a bonus for someone who comes along after you looking for something like this). Otherwise, feel free to close the question.

This question needs an answer!
Looks like this question is still being worked on. Think you can help?
Create your account and start contributing!
Create Account
Microsoft Visio

Microsoft Visio

--

Questions

--

Followers

Top Experts

Visio is a diagramming and vector graphics application that is part of the Microsoft Office family that allows the user to create diagrams for organizational and planning purposes. The Premium edition has additional templates for more advanced diagrams and layouts, as well as capabilities intended to make it easy for users to connect their diagrams to data sources and to display their data graphically, as well as intelligent rules, validation, subprocess (diagram breakdown). one-step connectivity with Excel data, information rights management (IRM) protection for Visio files, modernized shapes for office layout, detailed shapes for site and floor plans, modern shapes for home plans, and IEEE compliant shapes for electrical diagrams.