Paste shape into any location

[Chuck74]

Hello y'all. I created a shape with a fill color and can insert it into a cell.

I can then go to that cell and copy and paste it to another cell easily.
I don't want to have to go through that process every time and created
a macro to help. I need to tweak that macro.

I've placed that shape in a cell all by itself, and I've created a macro which
will take the program to that cell and copy it for me. I also have the macro
pasting that item to a particular cell.

So what I need is to be able to tell the macro to post it anywhere I desire,
not into the cell I wrote in the macro.

I hope this makes sense. I appreciate this forum and the members within
that so graciously give of their time to help newbies like me :-)

[6StringJazzer]

Please show us all of the code you have so far. Also, how do you want to specify "anywhere I desire"? A cell? A set of (x,y) coordinates? How will you determine that, and how do you want to communicate it to the code?

Macro Assistance Appreciated was not a very descriptive title so I changed it for you. Please take the time to review our rules. Take note of Rule #1.

[Chuck74]

Thank you 6StringJazzer -

Here is the code for the macro I created:

Please Login or Register  to view this content.

Moderator's note: Please take the time to review our rules. There aren't many, and they are all important. Rule #2 requires code tags. I have added them for you this time because you are a new member. --6StringJazzer

So B3 is the cell that has the green star shape inserted in it.
B26 was just a random blank cell on my worksheet where I pasted the green star,
to see if the macro did what I wanted. The macro worked perfectly.

I could also create another macro for the red star.

I want to be able to use ctrl + g (the macro) to paste a star into the cell of
my choice anywhere from B7 to H22.

I've attached the worksheet if that helps you visualize it. Thanks SO much.

[sintek]

Please Login or Register  to view this content.

[jolivanes]

Maybe (see attached)

[jolivanes]

Or maybe without macro buttons. (See attached)
These macros should be used for each shape. Replace what is currently in the attachment. (error checking added)

Please Login or Register  to view this content.

Please Login or Register  to view this content.

Please Login or Register  to view this content.

Please Login or Register  to view this content.