VBA Excel: Shape placement and shape counter

I've got a few questions about shapes in VBA Excel.

I've got Column A and Column B. They will be shown like this.

    A            B
1 | some text    1 to 5 shapes
2 | blabla       OOOO

I want to input the text and the shapes through a userform. So if a user selects '1', i want one shape to appear at the left of the cell in column B. If a user selects '3', I want 3 shapes to appear next to each other in column B.

Also, if someone firstly chooses to have 3 shapes, and wants to change it to 4 shapes later, I have to put the fourth shape in the right place.

All of this must still work if I change the widths of the columns.

I really googled a lot, but I can't seem to find a right solution.

Thanks in advance!