View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
chatterbox chatterbox is offline
external usenet poster
 
Posts: 11
Default Incorporating VB6 RichText control into Excel VBA

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