Can anyone help me with setting up and adding shapes to groups depending on their position on the worksheet. They are all pasted dynamically and regularly deleted and recreated, so usign their ID or name is difficult. They are a mixture of textboxes, arrows and pictures.
Hopefully the below code snippet will let you see what I'm trying to do
Please Login or Register to view this content.
Last edited by bluphoto; 11-19-2014 at 12:16 PM.
Could you post a sample workbook with just a few shapes to illustrate?
of course. sorry... (if I can work out how)
sample.xlsm
This still doesn't work (object doesn't support this property or method), but I think I'm getting there... Any help appreciated...
(I think my problem might be somthing around "Object.Name")
Please Login or Register to view this content.
Last edited by bluphoto; 11-19-2014 at 01:12 PM.
Try this. I'm out of time now but will take a look tomorrow if problems persist. I got a strange error on the .Left lines
Please Login or Register to view this content.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks