I've a small problem.
I'm creating a powerpoint presentation based on a data in excel.
The presentation consists of dozens of rounded rectangles with text in them, and depending on data, they may get a star, circle or other kind of things on top of them (small pictures).
I would somehow be able to group these shapes...
So far I'm creating the shapes(4 different shapes for now):
the 'main' rounded rectangle is named 'boxframe' & indexnr
star is named star & indernr (the indexnr is always same as in the box, so if there's a box with index 12, and it has data in it which qualifies a star on it, the star will be named star12.
and few more objects, similarly named.
I've counted how many boxforms there is on the sheet and made a loop through all of them, but then there's the problem. I've no idea how to check if the star @ that indexnr exists... if I knew I could just:
Note that the code in the tags is not real, it would give gazillion errors, but it's approx how i'm planning. Just, I've no idea how to check if a shape exists.
ps. this is not strictly an excel problem, but vba :P