greg.begin
Member
how do i name shapes based on cell values? then add a connetor line to a different shape?
vba code working with shapes.
- Thread starter greg.begin
- Start date
The first part is easy, something like
[pre]
[/pre]
The latter is a bit more tricky...you might want to read here:
http://peltiertech.com/WordPress/programming-excel-2007-2010-autoshapes-with-vba/
Lots of good references for dealing with shapes, including connectors.
[pre]
Code:
ActiveSheet.Shapes("Rectangle 1").Name = Range("A2").ValueThe latter is a bit more tricky...you might want to read here:
http://peltiertech.com/WordPress/programming-excel-2007-2010-autoshapes-with-vba/
Lots of good references for dealing with shapes, including connectors.
SirJB7
Excel Rōnin
Hi, Greg!
In this project I had to paste a lot of images as shapes on a worksheet and needed to handle logical and reasonable names:
http://chandoo.org/forum/threads/excel-multilanguage-formula-translator-and-function-reference.4789/
In this link I cut it keeping only the worksheet with the shapes and a worksheet "Work", which has the code involved in the processes of shape handling:
https://dl.dropbox.com/u/60558749/vba code working with shapes. (for Greg at chandoo.org).xlsm
Hope it helps.
Regards!
In this project I had to paste a lot of images as shapes on a worksheet and needed to handle logical and reasonable names:
http://chandoo.org/forum/threads/excel-multilanguage-formula-translator-and-function-reference.4789/
In this link I cut it keeping only the worksheet with the shapes and a worksheet "Work", which has the code involved in the processes of shape handling:
https://dl.dropbox.com/u/60558749/vba code working with shapes. (for Greg at chandoo.org).xlsm
Hope it helps.
Regards!
Last edited: