I am having a hard time getting formatted text back and forth between excel
and word. I can take the contents of an excel cell and (through the
clipboard) get it into word in the RichText Format (bold, font size..).

What I want to do is to be able to edit the text using word and then when
I'm done, I click Yes/No on a message box that is displayed from Excel. From
there, Excel will copy back (through the clipboard?) the changes that were
made in word, while keeping the RichText format (all styles [bold,
underline..], font faces, font sizes..). I can get the text back into the
cell, but the formatting is not kept.. only the plain text is.

The other problem is that anywhere there was a carriage return (enter key)
or tab (tab key) in word, it is copied back as a special symbol / character
into excel.. can I change the carriage returns into excel carriage returns
and the tabs into 5 spaces?

I can list the code that I am using to accomplish this if needed.