Why Experts Exchange?

Experts Exchange always has the answer, or at the least points me in the correct direction! It is like having another employee that is extremely experienced.

Jim Murphy
Programmer at Smart IT Solutions

When asked, what has been your best career decision?

Deciding to stick with EE.

Mohamed Asif
Technical Department Head

Being involved with EE helped me to grow personally and professionally.

Carl Webster
CTP, Sr Infrastructure Consultant
Ask ANY Question

Connect with Certified Experts to gain insight and support on specific technology challenges including:

Troubleshooting
Research
Professional Opinions
Ask a Question
Did You Know?

We've partnered with two important charities to provide clean water and computer science education to those who need it most. READ MORE

troubleshooting Question

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?

Avatar of Kelvin4
Kelvin4 asked on
Microsoft OfficeFonts TypographyMicrosoft ExcelVBA
1 Comment1 Solution176 ViewsLast Modified:
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
ASKER CERTIFIED SOLUTION
Avatar of Kelvin4
Kelvin4

Our community of experts have been thoroughly vetted for their expertise and industry experience.

Commented:
This problem has been solved!
Unlock 1 Answer and 1 Comment.
See Answers