Not sure I follow. You would just reference the item array
![]()
Dim vntItems As Variant Dim lngIndex As Long Set vntItems = ActiveSheet.ChartObjects(1).Chart.Shapes(1).Ungroup Set SecondBox = vntItems.Item(2) Set FirstBox = vntItems.Item(1)
Not sure I follow. You would just reference the item array
![]()
Dim vntItems As Variant Dim lngIndex As Long Set vntItems = ActiveSheet.ChartObjects(1).Chart.Shapes(1).Ungroup Set SecondBox = vntItems.Item(2) Set FirstBox = vntItems.Item(1)
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks