Blueorangez
New Member
- Joined
- Dec 15, 2016
- Messages
- 14
I have a sheet with a grid of rectangle shapes with text in them.
The grid is 6 columns across and 17 down.
The shapes can be moved around in their columns so this needs to be dynamic.
I need to get the text or the shape name or shape properties from all the shapes currently in that row and paste them to cells on the right side so I can perform calculations on data.
so what I'm trying to do is each of these shapes has a different value,
I can use the text or name the shape with its value.
but I need to get the info into the grid on the right so I can do some calculations
I see this working as a module with a run button, so the user can move the shapes in their columns throughout the day than when they are ready to calculate the hit run. The values move over to the right and excel formulas add the relevant info up for them.
if it's easier it could be on a new sheet, if there is VBA to get arrays from all shapes on a sheet and paste them as text to another sheet.
The grid is 6 columns across and 17 down.
The shapes can be moved around in their columns so this needs to be dynamic.
I need to get the text or the shape name or shape properties from all the shapes currently in that row and paste them to cells on the right side so I can perform calculations on data.
so what I'm trying to do is each of these shapes has a different value,
I can use the text or name the shape with its value.
but I need to get the info into the grid on the right so I can do some calculations
I see this working as a module with a run button, so the user can move the shapes in their columns throughout the day than when they are ready to calculate the hit run. The values move over to the right and excel formulas add the relevant info up for them.
if it's easier it could be on a new sheet, if there is VBA to get arrays from all shapes on a sheet and paste them as text to another sheet.