I'm trying to hold Rich Text Formatted text in a series of cells in an excel spreadsheet and be able to edit them as if they were word objects. I have a VBE form with an InkEDit control on, so I can display the RTF within the form ok. However, I would also like to be able edit the text, and rather than reinvent a UI with buttons and trapping keypresses, I figured just pasting the cell contents into Word should give allow the end user to use Word to format and edit the text.

The questions I have are:
1. The best way to get the data from Excel into the word doc (I have a blank document with the correct styles in place to use for editing) the text is in an InkEdit control and also in a cell.
1. How to get Excel to wait until the user has finished editing the word document?
2. How to pull back the data and store it back into the cell?

TIA