Pasting Text at the Cursor Point in a Textbox

Hi everyone.

I have been sieving through the forums for hours now and can't seem to get an answer that suits my needs.

On a userform I have several textboxes and at some point the user may want to highlight a section of text from textbox1 (lets say) and copy and paste it into another textbox (this could be one of 20). The two issues I need solving are as follows:

1. The text being pasted needs go in the textbox the user currently has the cursor in, and
2. The text needs pasting at the cursor location within that textbox.

I have already worked out how to copy the selected text to the clipboard. It is now just a matter of working out how to paste it from the clipboard to a specific location - this appears to be somewhat trickier.

Also, I have considered adding a right-click option for the user but I'm not convinced by my users computing abilities so want to set the copy and paste up as two separate buttons.

Thanks for any help in advance!

Hi Tiger,

Thanks for getting back so quickly.

I probably wasn't clear enough. Yes I am aware of ctrl c and v however I want the user to be able to do copy and paste of the text they have highlighted using two buttons.

I have attached an example of my problem.

You will see that the two buttons, copy and paste on the the userform. I have already stolen code from another post that allows me to copy the highlighted text (lets say all the text from tb1 in my example). I then want the user to be able to paste the text at the cursor location in whichever text box they are currently writing in. In the example case, tb4.

I hope this makes it a bit clearer.

My apologies. The sheet I attached isn't working. Here is a version that does.