Combining Font Types

B

BillCPA

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?
 
B

Bernard Liengme

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

best wishes
Bernard
 
B

BillCPA

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?
 
Top