Good morning!
Please allow me to explain what I am trying to accomplish. I will do my best to be brief and to the point.
In Excel tab "Process A" - Column A = Process Step Description (Connector, Decision, Process). Shapes will be created from these on a new tab (Circle, Diamond, Rectangle).
Column B = The "Top" start point for each shape
I want to review the range of cells in both rows. I would like for a new shape to be created with each loop. The shapes will be built from the following data prompts (msoShape, Left, Top, Width, Height). I will need a conditional statement to say "If the first shape in column A is a connector then AddShape(msoShapeFlowChartConnector,Left, Top, Width, Height) but if its a decision.....).
Much of the data in the prompter are constant values. The one piece that's not is the "Top". How do I loop through Column B and get that value to fill into the data prompter with each loop? My attempts thus far have simply resulted in all the shapes being produced but stacked on top of each other. Any help you can provide will be very much appreciated as I feel like I am doing nothing more than running into a brick wall. Thank you in advance!
Bookmarks