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!
Which version of Visio? Visio does have an auto numbering feature, have you tried that?
Wapperdude
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 (http://visguy.com/vgforum/index.php?topic=6686.msg27867#msg27867)
Hope this helps,
- Ken
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.