View Single Post
 
Old 12-12-2024, 05:03 PM
Guessed's Avatar
Guessed Guessed is offline Windows 10 Office 2016
Expert
 
Join Date: Mar 2010
Location: Canberra/Melbourne Australia
Posts: 4,176
Guessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant future
Default

There should be no need to ungroup the shapes as you can resize and move them as child elements. For instance,
Code:
            'shpGroup.Ungroup
            Debug.Print shpGroup.GroupItems.Count
            For Each shp In shpGroup.GroupItems
              If shp.Name = "1" Then Set L = shp
              If shp.Name = "2" Then Set C = shp
              If shp.Name = "3" Then Set R = shp
            Next
Having said that, I haven't taken the time to figure out the desired width and offsets and find the characters in the selected text stylename and right to left is not helping.
__________________
Andrew Lockton
Chrysalis Design, Melbourne Australia
Reply With Quote