I've always had problems with the Rich Text control in VBA. You
might be better off using a VB6 Form in your DLL to contain the
Rich Text control.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com


"chatterbox" wrote in message
oups.com...
Hi everybody.

I'm working with a VBA userform that allows the user to enter
text into
one of the text box controls. The brief includes a requirement
to
highlight sections of text which are in error. I understand
that text
boxes do not support multiple fonts, therefore can someone
provide me
with step by step instructions on how to incorporate a VB6
RichText
control into VBA ? I would be most grateful.

I have to forward the finished project to external users in a
secure
fashion and therefore may have to create a VB6 dll. Would I be
better
off passing my VBA code to VB6 and adding the RichText control
at that
time ? Finally, do I need to consider whether the RichText
control is
compatable with older versions of Excel ?

Thanks very much. Chatterbox