Copy paste Text Box

Hello,

I've created this simple code which copies and pates a textbox.

Please Login or Register  to view this content.

My goal was to select a cell, run a macro which copies a textbox and pastes it on the selected cell.

Currently, the code pastes it in the middle of my worksheet.

How can this be modified to paste on the cell?


Thanks for any help.

~Jeff

Thanks, Ikaabod

The second code that loops is quite interesting... I can see areas where this can be used.

.. however, in my situation, It's an interactive process which will vary, so I'll need the position of the texbox to paste on or near the active cell...



any other ideas?

thanks


Jeff

.

You can change the offset to whatever you need. Use zero if you want it in the activecell.

Please Login or Register  to view this content.

Thanks Ikaabod!

Your code, interestingly, pastes a "rectangle" object, not a Text Box.
.. perhaps its a default setting for objects.

either way it provided me with a workable solution.

Please Login or Register  to view this content.

Thanks for the help!

~Jeff