Incorporating VB6 RichText control into Excel VBA

[chatterbox]

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

 

[Chip Pearson]

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

 

[Perico]

Chip, is it possible for you to show me a brief code example how that would
be done? I'm confused as to how a rich text control is wrapped by a VB6
UserControl or Form and then incorporated into the Excel VBA. Do you import
the VB6 Form or UserControl into the Excel VBE? Do you first have to save
the VB6 Form in a VB6 project? As you can see, I'm just not clear about the
details how you incorporated what you develop in VB6 into an Excel program.