Thanks, gmayor for taking the time out to look at this for me.

I think I need to clarify a few bits of information that were ommitted from my original post.


The data that I need to transfer from Excel to Word is generated in Excel and is put into the clipboard from the same application. I have ensured that everything that I need to copy over is present and correct by opening a blank Word document and then pasting the contents into this by using the default paste button, selecting the "keeping the source formatting" option.

Both applications will be open and both will be using a VBA UserForm to perform their respective tasks.

The TextBox I need the content to arrive in (Word), is a UserForm TextBox which is currently called "TextBox3". It is Word that will be producing the final document.

The best that I have managed to achieve is the content being "copied" into TextBox3 but minus the formatting. Even copying from Excel and then pasting into the TextBox3 loses the required bold formatting.

The most frustrating thing is that the important formatting that I need to keep is certain pieces of text that are bold.