Under control of MS Excel - how to compose rich text sentences (with mixed font features in the same sentence) and automatically copy-paste the sentences to other office applications?

The standard UserForm does not allow mixed fonts to be entered into the same Text control. Under excel vba control, I want to type simple rich text for scientific notation: superscript, subscript, italic, with SYMBOL font plus one or just a few standard fonts, like Calibri, or Tahoma, for example.
These formatting features to be applied together (in various combinations) to just a sentence or two, in each instance.

If this is possible, I'd then want to use vba automation to copy the rich text output and paste it into another office format: particularly into a shape object in MS Visio. I'm aware that mixed text can be composed in Visio shapes directly, but in my excel+visio automation piece, it would greatly help the user to compose rich text outside the visio application.

Is there a way of achieving this?

Thanks
Kelvin
Kelvin4Asked:
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Kelvin4Author Commented:
Here's the simple solution that occurred later, if experts have different practicable solutions, then i'll give over my POINTS to you!

Solution:
1. Type the mixed font text (respective characters = bold; superscript; italic; symbol; underline) into an excel cell.
2. Select Cell and copy
3. Paste onto Visio drawing page, to yield orthodox visio shape displaying the same characters and fonts. This new shape has a shapesheet, like any other shape.
4. The CHARACTER section of the shapesheet presents the font name & size; colour; style; case; and position. This can be parsed into HTML, as a portable source of the rich text created.

This is not a perfect solution as it seems not to be possible to copy text of one font name and preserve that font when it is pasted after a character of a different font.
However, this solution does help me.
Kelvin

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Fonts Typography

From novice to tech pro — start learning today.