<div>
<div class="content wysiwyg-content">
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.<br />
These formatting features to be applied together (in various combinations) to just a sentence or two, in each instance. <br />
<br />
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.<br />
<br />
Is there a way of achieving this?<br />
<br />
Thanks<br />
Kelvin
</div>
</div>


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

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?

A font is a particular size, weight and style of a typeface. Each font is a matched set of type, one piece (called a "sort") for each glyph, and a typeface consists of a range of fonts that share an overall design. With the advent of digital typography, font is frequently synonymous with typeface, although the two terms do not necessarily mean the same thing. In particular, the use of "vector" or "outline" fonts means that different sizes of a typeface can be dynamically generated from one design. Each style may still be in a separate "font file" -- for instance, the typeface "Futura" may include the fonts "Futura roman", "Futura italic", "Futura bold" and "Futura extended" —- but the term "font" might be applied either to one of these alone or to the whole typeface.

Fonts Typography

Visual Basic for Applications (VBA) enables building user-defined functions (UDFs), automating processes and accessing Windows API and other low-level functionality through dynamic-link libraries (DLLs). VBA is closely related to Visual Basic and uses the Visual Basic Runtime Library, but it can normally only run code within a host application rather than as a standalone program. It can, however, be used to control one application from another via OLE Automation. VBA is built into most Microsoft Office applications.

Microsoft Excel topics include formulas, formatting, VBA macros and user-defined functions, and everything else related to the spreadsheet user interface, including error messages.

Microsoft Excel

Microsoft Office is an integrated suite of applications that includes Outlook, Word, Excel, Access, PowerPoint, Visio and InfoPath, along with a number of tools to assist in making the individual components work together. Coding within and between the projects is done in Visual Basic for Applications, known as VBA.