Dynamic Create and Position Shapes According to Cell Values for All Rows on a Worksheet

Hi

Can you please edit your post and surround your code with code tags as per the forum rules.

Then can you please advise exactly where the data you have provided is located on the sheet. I started things in A1, but this doesn't gell with the way I read your code.

rylo

Sorry, I thought I had put code tags around it. Thanks Moderator for helping me out. I attached the spreadsheet itself to show where the data is. The column names start in A1 but the widths and heights start in j1 and ki1 (I had to multiply them by 100 to get the right size).

Please Login or Register  to view this content.

Hi

First thing I'd do is add some additional columns with formulas that will work out all the relevant positions for the shapes and put them beside the existing height / width columns. Things like toppos, leftpos etc. Same thing for the RGB values. That way you can do a loop on all the items, and just pick up the relevant positioning items and color items from the row entries.

rylo

I've got a loop working but I can't figure out how to remove the hard-coding (i.e. instead of having if i=2 or i=4, etc have variables). I know I'll have to probably do something with Mods but not sure what. Also, I want to keep looping for all rows that have a value (whereas this is limited to row 17). Here is the updated code, any ideas?

Please Login or Register  to view this content.

Hi

Upload a new example file that has all the extra positioning and color options.

rylo