Author Topic: Increase number in shape text  (Read 3221 times)

0 Members and 1 Guest are viewing this topic.

emorales1992

  • Newbie
  • *
  • Posts: 2
Increase number in shape text
« on: March 10, 2017, 04:54:24 AM »
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

  • Global Moderator
  • Hero Member
  • *****
  • Posts: 4449
  • Ideas Visio-lized into solutions
Re: Increase number in shape text
« Reply #1 on: March 10, 2017, 10:08:12 AM »
Which version of Visio?  Visio does have an auto numbering feature, have you tried that?

Wapperdude
Visio 2019 Pro

Hey Ken

  • Full Member
  • ***
  • Posts: 233
  • Just This Guy
    • The Pennsylvania Project, with Ken Krawchuk
Re: Increase number in shape text
« Reply #2 on: March 10, 2017, 02:52:11 PM »
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

  • Newbie
  • *
  • Posts: 2
Re: Increase number in shape text
« Reply #3 on: March 13, 2017, 03:18:58 AM »
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.