I think your work around would be to get the documentation on RTF codes and
write code to interpret them. then you could place the text string in the
cell and have you code format it based on the interpretation of the RTF
codes. Sounds like a lot of work.

--
Regards,
Tom Ogilvy


"Robert Mulroney" '''' wrote in message
...

Ah,

http://support.microsoft.com/default...b;en-us;213693

Anyone got a work around?

- Rm


"Robert Mulroney" wrote:


I plan to write a form that uses the Rich Textbox control. Can anyone
advise
me the best way to get the formatted text from the control into an excel
worksheet cell, keeping as much of the formatting as possible?

I'd like to avoid using the clip board if that's possible.

Additionally is there a simple way to strip out all the rich text tags
from
a rich string leaving only the text?

cheers,

Rm