Increase number in shape text

Started by emorales1992, March 10, 2017, 09:54:24 AM

Previous topic - Next topic

0 Members and 1 Guest are viewing this topic.

emorales1992

Hello,

I am trying to create a set of squares with a consecutive number as text. My idea is to create a square, set its text as a number (for example number 1) and link the other shapes' text to it with a formula in order to increase that number. I would like to add a huge number of squares so I am seeking a way to automate that task.

I am quite new in Visio so I don't really know how could I do that. I have seen that text fields can be assigned to ShapeSheet fields or even to Excel data. The main problem that I have is that I don't know how to automate the process (I guess that I have to apply a macro).

Does anyone know how can I do this?

Thank you very much!

wapperdude

Which version of Visio?  Visio does have an auto numbering feature, have you tried that?

Wapperdude
Visio 2019 Pro

Hey Ken

Emorales:

   Welcome to the forum!

   A few years ago I posted a way to have callouts automatically number themselves, but it can be applied to any Visio shape.  Might be just what you need.  Better still, it needs no macros; it's all done with shapesheets.  Check it out: http://visguy.com/vgforum/index.php?topic=6686.msg27867#msg27867

   Hope this helps,

   - Ken
   

Ken V. Krawchuk
Author
No Dogs on Mars - A Starship Story
http://astarshipstory.com

emorales1992

Hi Wapperdude, I am using the versio 2013.

Thanks Hey Ken, that was really usefull. Do you know how could I do it if, for example, I have 2 squares with consecutive numbers (1, 2) grouped with other shapes. I would like to copy and paste the whole group and see that the next copy has the squares numbered as 3, 4.

I guess I should set the EventDrop field of the group as you did with the shape but referaring to the squares, but I don't know exactly how to set that formula.

Thanks for your time.