Combining Font Types
 

Is there a way to combine two different font styles for display as the
Label.Caption on a user form? I need to concatenate a character from the
'Symbol' set with a standard letter (A-Z) and display the combination as the
..Caption for a form label. But the font description (Arial) for the label
replaces the 'Symbol' character with the Arial equivalent. Is there any way
to display two different font styles together?

--
Bill @ UAMS

Try this.
Type abcdefg in a cell
Now highlight just the D and change the font to symbol
You should see abs<deltaefg; where ,delta. is the Greek D looking like a
triangle.

best wishes
Bernard

"BillCPA" <Bill @ UAMS wrote in message
...
Is there a way to combine two different font styles for display as the
Label.Caption on a user form? I need to concatenate a character from the
'Symbol' set with a standard letter (A-Z) and display the combination as
the
.Caption for a form label. But the font description (Arial) for the label
replaces the 'Symbol' character with the Arial equivalent. Is there any
way
to display two different font styles together?

--
Bill @ UAMS

That works fine in a cell on a worksheet.

But apparently on a User Form (in VBA), the Font selection controls all of
the characters in the Caption. If a 'Symbol' character is part of the string
that makes up the Caption, the font style replaces the 'Symbol' character
with the font equivalent.

Any other suggestions?


"Bernard Liengme" wrote:

Try this.
Type abcdefg in a cell
Now highlight just the D and change the font to symbol
You should see abs<deltaefg; where ,delta. is the Greek D looking like a
triangle.

best wishes
Bernard

"BillCPA" <Bill @ UAMS wrote in message
...
Is there a way to combine two different font styles for display as the
Label.Caption on a user form? I need to concatenate a character from the
'Symbol' set with a standard letter (A-Z) and display the combination as
the
.Caption for a form label. But the font description (Arial) for the label
replaces the 'Symbol' character with the Arial equivalent. Is there any
way
to display two different font styles together?

--
Bill @ UAMS